CICS-DB2 Interface: Optimise for Performance

Course Code: DZOCIC
Duration: 1 day
Audience: Database Administrators, Capacity Planners, System Administrators, System Programmers and Application Developers.
Prerequisites: A working knowledge of CICS and DB2, their components and architecture.
Summary: This presentation focuses on CICS-DB2 design and performance:
  • RCT(RDO) options – DB2CONN, DB2ENTRY & DB2TRAN
  • Thread creation, reuse and termination
  • Plans vs. Packages
  • How to control deadlocks (-911)
  • Accounting and monitoring
Objectives: Upon completion of this presentation, the participant should be able to use DB2 accounting and statistical reports to monitor and tune the CICS-DB2 interface:
  • Optimise thread reuse
  • Control deadlocks
  • Optimise the DB2CONN, DB2ENTRY and DB2TRAN entries
  • Optimise BIND/REBIND parameters
  • Etc.
View full outline in PDF formatDetailed Outline

print  |  top of page