1 / 46

Advantage CA-IDMS Release 16 Beta Experience

Advantage CA-IDMS Release 16 Beta Experience. UKIUA 2004 Roadshow. Session Abstract. This session details the experiences of British Telecom in Beta Testing CA-IDMS Release 16. Topics discussed include: Why British Telecom is a Beta Test Site Implementing Advantage CA-IDMS Release 16

vevay
Download Presentation

Advantage CA-IDMS Release 16 Beta Experience

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Advantage CA-IDMS Release 16 Beta Experience UKIUA 2004 Roadshow

  2. Session Abstract • This session details the experiences of British Telecom in Beta Testing CA-IDMS Release 16. • Topics discussed include: • Why British Telecom is a Beta Test Site • Implementing Advantage CA-IDMS Release 16 • Performance Testing • Testing of New Features including • Online Execution of Utilities • TCP/IP Interface • SQL Caching • Two-Phase Commit • File Cache in Memory • Interesting Problems Encountered

  3. Biography • Steve Terry British Telecom • Steve has worked for British Telecom for 28 years, 15 of these as an Advantage CA-IDMS Systems Programmer. Steve installs and supports Advantage CA-IDMS for BT's Business Systems, consisting of 10 major applications running across 60 CVs.

  4. Agenda AGENDA • Advantage CA-IDMS at British Telecom • Why British Telecom is a Beta Test Site • Implementing Advantage CA-IDMS R16 (Beta) • Regression and Performance Testing • Testing the New Features • Interesting Problems Encountered • Questions and Answers

  5. Advantage CA-IDMS at British Telecom ADVANTAGE CA-IDMS AT BRITISH TELECOM • Advantage CA-IDMS at BT - Two Configurations: • CSS - Customer Service System • BT’s Largest Computer System • CICS Front End System • Split Into 29 Regions of the UK • 13.4 Terabyte Database • Each Region Has One Update, Two Read Only (and One Maintenance CV) • 24x7 • 10 Billion+ Transactions per Year • Additional 28 CVs for Development, Test, Training

  6. Advantage CA-IDMS at British Telecom • Advantage CA-IDMS at BT - Two Configurations: • 6 Major Business Systems • Fault Repair, Specialist Billing and Provision, Exchange Planning, Traffic Analysis • CAMSS (Computer Assisted Maintenance for Special Services) • Private Circuit Repair - Demanding Customers • Advantage CA-IDMS/DC ADS/COBOL • 24xForever Using Hot Standby • Up to 1000 Concurrent Online Users • 1 Million + Tasks Per Day • 3 Million + Transactions Per Day

  7. Advantage CA-IDMS at British Telecom • Summary of Advantage CA-IDMS in BT • Total of 230 Advantage CA-IDMS CVs • 9 Full Time Advantage CA-IDMS DBAs • 4 Full Time People Providing a Central Support Role • BT has achieved World Number One status for cost effective use of the Mainframe (z/OS),as measured by Gartners 'NoW' index, for the past three years. • The CSS Database Achieved Second Position in the Winter Top Ten Worldwide Survey of Largest Databases in the OLTP Environment

  8. Why BT is a Beta Test Site WHY BRITISH TELECOM IS A BETA TEST SITE • Advantage CA-IDMS Runs Our Major Systems • We Need to Ensure New Releases are ‘Fit for Purpose’ • Gives BT an Input into the Development Process • Helps Us Ensure Compatibility With Our Bespoke Software (Exits e.t.c.) • Gives Us a Long Testing Period • Assists us in Providing a ‘Trouble Free’ Implementation • BT Has Been a Beta Test Site Since 10.2

  9. Implementing Advantage CA-IDMS R16 IMPLEMENTING ADVANTAGE CA-IDMS R16 • Test LPAR: • Z900 (now upgraded to Z990) • z/OS 1.4 • SYSPLEX (Not Exploited) • CSS Advantage CA-IDMS System • CAMSS Advantage CA-IDMS System

  10. Implementing Advantage CA-IDMS R16 • Advantage CA-IDMS R16 Installed into New SMP/E Environment (March 2003) • “We Installed it and it Worked” (almost) • One install ‘bug’ found • APPLY of RHDCLEFE USERMOD failed • Function CGJG013 was missing from RECEIVE/APPLY steps • Fixed on Beta 2 Tape

  11. Implementing Advantage CA-IDMS R16 • Format Journals & Log • Re-assemble User Exits and Programs that Reference Advantage CA-IDMS DSECTs • Load New SVC • Run IDMSDIRL, Update Protocols, Reports and Messages • SYSGEN to Update TASKs and PROGRAMs • SQL • Update SYSCA Schema • CONVERT CATALOG

  12. Implementing Advantage CA-IDMS R16 • Upgrade Was Relatively Simple • No Major Problems Found • Upgrade Completed in a Matter of Hours • No Changes to Bespoke Software at this Stage

  13. Implementing Advantage CA-IDMS R16 • Startup CV

  14. Regression and Performance Testing REGRESSION AND PERFORMANCE TESTING • CHECKLIST Provided by CA • Very Detailed List of All Functions to be Tested • CSS • TPNS (TeleProcessing Network Simulator) • Runs Application Using Scripts - One Hour Test Runs • Performance Compared to Advantage CA-IDMS R15.0 • No Noticeable Difference Found • CAMSS • User Testing of Application • Limited CA-Verify Testing

  15. Testing the New Features - Online Utilities TESTING THE NEW FEATURES • Online Execution of Utilities • CLEANUP SEGMENT • FIX PAGE • FORMAT AREA • FORMAT SEGMENT • INSTALL STAMPS • LOCK AREA • PRINT INDEX • PRINT PAGE • PRINT SPACE FOR AREA • PRINT SPACE FOR SEGMENT • SYNCHRONIZE STAMPS • TUNE INDEX • UPDATE STATISTICS

  16. Testing the New Features - Online Utilities • Online PRINT PAGE

  17. Testing the New Features - Online Utilities • Some Commands You May Want To Secure • #UTABGEN Implemented to Provide Security • Sample Provided: • IDMSUTAB Member of Source Library

  18. Testing the New Features - Online Utilities • Assemble #UTABGEN Macro

  19. Testing the New Features - Online Utilities • Create Resource and Grant Access for OCF/BCF

  20. IDMS TCP/IP Application TASK ABC Testing the New Features - TCP/IP • TCP/IP Interface • ‘Client’ • Task Running Within Advantage CA-IDMS CONNECTS to Another TCP/IP Application

  21. IDMS TCP/IP Application Testing the New Features - TCP/IP • TCP/IP Interface • ‘Server’ • Advantage CA-IDMS ‘Listens’ for an Incoming CONNECT • When a CONNECT is Received, CA-IDMS Dispatches a Task to Communicate with the Remote Application • Generic Listening Service Provided by Advantage CA-IDMS TASK XYZ

  22. Testing the New Features - TCP/IP • Server - Generic Listener • TCPxxx01 Members of Source Library have Sample Code for a Program to Handle Incoming Requests • xxx = ADS, ASM, COB, PLI • Sample Programs in Features Guide • New Call to IDMSIN01 • ASCII / EBCDIC Conversion

  23. TCP/IP Address nnn.nnn.nnn.nnn Port Port Port Port Port Port Port Port Port Port Port Port CA-IDMS CCITCP FTP TELNET Testing the New Features - TCP/IP • SYSGEN Definitions • For Generic Listening • ADD PTERM / LTERM Type is LISTENER for PORT pppp • Listens on PORT pppp for an Incoming Connection • When Connection is Received, Task is Started • All Subsequent Communication is via BULK PTERM / LTERM

  24. Testing the New Features - TCP/IP • Generic Listening SYSGEN • ADD LINE and LISTENER PTERM / LTERM • ADD Multiple BULK PTERMs / LTERMs • Can Use New REPEAT Clause

  25. Testing the New Features - TCP/IP • PTERM REPEAT • PTERM/LTERM Cloned repeat count Times at Startup • Name Must End in Sequence Number

  26. Testing the New Features - TCP/IP • Sample TCP/IP Server Program Used • COBOL Prog INVOKED by Listener PTERM Task Code • READs Incoming Data CALL 'IDMSOCKI' USING SOCKET-FUNCTION-READ, SOCKET-RETCD, SOCKET-ERRNO, SOCKET-RSNCD, SOCKET-DESCRIPTOR, READ-BUFFER, BUFFER-LENGTH, RETLEN • Calls IDMSIN01 to Convert ASCII to EBCDIC • #WTL Incoming Data to the Advantage CA-IDMS log • WRITEs Data Back to Sender • JAVA Program on PC Used to Generate Traffic

  27. Testing the New Features - TCP/IP • Test Scenarios • Try Listening on an Occupied Port • Line Closed - Full Error on CA-IDMS Log • Try Multiple Simultaneous Connections • More Connections than Bulk PTERM/LTERMs Available • DC088003 "Line line-id generic listening: no BULK PTE (count)” • Prevent Task from Getting Dispatched • MAX CONCURRENT Set on TASK Statement • Returns Null Read to Client

  28. Testing the New Features - TCP/IP • Line / PTERM / LTERM Statistics

  29. Testing the New Features - TCP/IP • Client Program Testing • ASM Program Written to Invoke a Connection • Sample Programs in SRCLIB and Manual • SOCKET / CONNECT Macros Establishes Connection #SOCKET CONNECT,SOCK=SOCKDESC, X SOCKADDR=SOCKADDC,SOCKADDL=SADDCLEN, X RETCODE=RETCODE,ERRNO=ERRNO,RSNCODE=RSNCODE • READ / WRITE Macros Transfer Data • JAVA Server Program Used on PC • Easy to Set Up - Working Example in a Few Hours

  30. Testing the New Features - TCP/IP • TCP/IP Security • Security—At the moment the program receives control, no signon is done. For security reasons, the executing program should be coded so that the first thing it does is signon. • No Facility Supplied to Encrypt Data • Would Not Want to Pass Userid/Password in Clear Text

  31. Testing the New Features - SQL Caching • Dynamic SQL Caching • Caches Compiled Dynamic SQL Statements • Reduces Catalog/Dictionary Access for Cached Statements • Turn On for CV Via SYSGEN ADD SQL CACHE • Turn On for Batch Via New SYSIDMS Parm SQL_CACHE_ENTRIES=n

  32. Testing the New Features - SQL Caching • Use Controlled via SQL Tables • DSCCACHEOPT • Manages SQL Cache Options • Reflects SYSGEN settings • Used to Modify Caching Settings when CV is active e.g. • INSERT INTO SYSCA.DSCCACHEOPT VALUES (20, 'ON')Enables SQL Caching if Caching is not turned on in SYSGEN • No DCMT Commands for Displaying or Varying SQL Cache • No Facility to Quantify Storage Used

  33. Testing the New Features - SQL Caching • Table DSCCACHEV Provides a View of the Cache

  34. Testing the New Features - SQL Caching • Tested Simple Dynamic SQL Statements • SELECTs from a NONSQL Schema • SELECT OFFICER_SURNAME_1700 FROM SQLCITY."FRP-622", SQLCITY."USER-1700” WHERE AREA_CODE_622='TV' AND FRP_CODE_622='000' AND USERID_1700='MRBDL001’; • IDMSBCF • 5 Different SQL Statements, Each Executed 100 Times

  35. Testing the New Features - SQL Caching • Big Performance Gains Can Be Achieved • Literal Comparison of SQL Syntax (for Performance) - Syntax Must Match Exactly • SELECT * FROM SYSCA.ACCESSIBLE_TABLESis NOT the same in a Literal Comparison as • select * from sysca.accessible_tables • Ideal for Pre-Coded Dynamic SQL Statements • Web Interface to Advantage CA-IDMS

  36. Testing the New Features - File Cache • File Cache in Memory • z/Architecture and z/OS Allow Access to 16 Exabytes of Storage (64 Bit Storage) • Files can be Cached in 64 Bit Storage (Above the Bar) • Reduced Physical I/O • JES MEMLIMIT parameter can be used to limit 64 Bit Storage Use • If 64 Bit Storage is Not Available, a Dataspace will be used - Not Documented

  37. Testing the New Features - File Cache • File Cache in Memory • Turn on in DMCL for Permanent Change • Or Via DCMT For Temporary Change

  38. Testing the New Features - Two-Phase Commit • Two-Phase Commit • Ensures That All Changes Made Within the Scope of a Distributed Unit of Recovery Are Either Applied or Backed Out • BT Has Only Tested CICS Transaction Server • CICS Transaction Updating 2 Separate CVs • Limited Recovery Testing was Done • Controlled Recovery Testing Would be Nice to Do • BT Has No Plans to Use This Feature at This Time

  39. Interesting Problems Encountered INTERESTING PROBLEMS ENCOUNTERED • CV Abend S0C9 on Startup After Clock Change • Calculation of Local Time Giving Negative Leap Seconds • Not a Problem if you have an ETR • DCMT DIS FILE No Longer Displayed VOLSER • Fixed on Beta 2 Tape • DCPROFIL Showed 32000+ Optional Bits OnOPT17389 OPT17390 OPT17391 OPT17392 OPT17393 OPT17394 OPT17395 OPT17396 OPT17397 OPT17398 OPT17399 OPT17400 OPT17401 OPT17402 OPT17403 OPT17404 OPT17405 OPT17406 OPT17407 OPT17408 OPT17409 OPT17410 OPT17411 OPT17412 OPT17413 OPT17414 OPT17415 OPT17416 OPT17417 OPT17418 OPT17419 OPT17420 OPT17421 OPT17422 OPT17423........

  40. Interesting Problems Encountered • How Can I Tell if PAV Support is in Use? • You Cannot Tell from Advantage CA-IDMS • Used if a Device Supports it, and is Defined for PAV • Database Corruption on Rollforward • Updates Not Backed out on Rununit ABRT • Caused by Missing Comma in Source Code!

  41. Interesting Problems Encountered • Changes to Startup Processing Sequence • Caused the BT SVC Exit Problems • ESE Address in the CSA Wasn't Being Filled in When Exit Was Called • Startup Sequence Was Modified to Meet Our Needs

  42. Interesting Problems Encountered • Abend in IDMSTMGR with DMLO User Exit • DMLO Exit Opens a Second Run Unit • Abend Caused by Bug in New Transaction Sharing Feature • Transaction Sharing Was Turned OFF in SYSGEN! • Why was it Being Used? • SYSGEN Had Been Migrated from 10.2 • Residual Data was in the Transaction Sharing Indicator • SYSGEN Quiesce Wait Option Also Had This Problem

  43. Interesting Problems Encountered • CV Shutdown Waiting for Journal Offload • DCMT VARY FILE ACTIVE had corrupted a Journal • Journal Was Full and Could Not Be Offloaded • CV Would Not Shutdown - Waiting on Offloading JRNL • CV had to be Cancelled • Changed Not To Wait for Offloading JRNL on Shutdown

  44. Session Summary SESSION SUMMARY • Being a Beta Test Site Was an Enjoyable and Worthwhile Experience • Problems Were Identified and Rectified Which Would Have Impacted BT • CA Were Very Responsive and Helpful • R16 Appears to Perform as Well as R15 • Some Useful New Features to Explore

  45. Questions & Answers

  46. Session Evaluation Form After completing your session evaluation form ... ... please place it in the basket at the back of the room.

More Related