Teleconference replay: CICS Performance - Blow the doors off CICS DB2

Content

Date: 13 January 2009

Speaker: John Tilling, Senior Software Engineer, CICS Technical Planning and Strategy

Developed for: CICS application managers, CICS systems managers, CICS system administrators, CICS developers, performance administrators

Technical level: Intermediate - advanced

Description:

• Would you like to save costs on your CICS and DB2 applications?
• Are your applications straining with DB2 data that has gone through the roof?
• Are you fed up with system bottlenecks caused by high TCB switching?
• Would you like to blow the dust off CICS and DB2 applications and make them fly?

You can reap more rewards from your CICS and DB2 environment by tuning your CICS to DB2 interfaces, connections, and interactions to get the most from your tried and tested applications. Not only can this provide significant performance improvements for applications issuing large numbers of EXEC SQL requests, it can also go a long way toward reducing your software bills.

John discusses optimizing DB2 performance for various application configurations, threadsafe standards, and the benefits of threadsafety. The session also covers how exploitation of threadsafe and OTE can help:

• Boost performance
• Reduce machine cycles
• Reduce TCB switching
• Reduce bottlenecks

This presentation was given before CICS TS V4.1 and higher became available, but the concepts of threadsafe CICS-DB2 programs applies equally to newer releases of CICS and DB2. There are further enhancements in CICS TS V4 that are described in the latest version of the IBM Redbooks publication Threadsafe Considerations for CICS.(publish date 5 April 2012). In addition, CICS TS V5 has further enhancements for CICS Java applications accessing DB2 as documented in the CICS TS V5.1 information center under Removal of TCB switch for Java applications accessing DB2.

Replay information
To replay this 70 minute presentation, click on Download Audio Audio (8 MB) to access the MP3 file then open the PDF file below:

Presentation (in PDF format):




Get Adobe Reader to view PDF.

Right-click and select Save As to store the files on your local computer for later playback.

Problem listening to the audio replay?
If you are having a problem listening to the audio when you use a left-click on the audio link above, you need to download the MP3 file to your local computer before playback by doing a right-click and selecting Save As.