Monitoring a CICS DB2 environment: Overview
The objective of monitoring the CICS® DB2® attachment facility is to provide a basis for accounting and tuning.
About this task
You can use monitoring to obtain the following data:
- The number of transactions accessing DB2 resources.
- The average number of SQL statements issued by a transaction.
- The average processor usage for a transaction.
- The average response time for a transaction.
- The cost associated with particular transactions.
- Buffer pool activity associated with a transaction.
- Locking activity associated with a transaction. This includes whether table space locks are used instead of page locks, and whether lock escalation occurs, for example due to repeatable read.
- The level of thread usage for DB2ENTRYs and the pool.
- The level of thread reuse for protected threads in DB2ENTRYs.
It is recommended that you monitor your test environment
for the following reasons:
- To check that new programs function correctly (that is, use the correct call sequence) against test databases.
- To detect any performance problems due to excessive I/O operations or inefficient SQL statements.
- To detect bad design practices, such as holding DB2 resources across screen conversations.
- To set up optimum locking protocols to balance the application isolation requirements with the requirements of existing applications.
Include monitoring in the acceptance procedures for new applications so that any problems not detected during the test period can be quickly identified and corrected.
You
can use some, or all, of the following tools to monitor the CICS DB2
attachment facility and CICS transactions that access DB2 resources.
- Monitor the CICS DB2 attachment facility using:
- CICS DB2 attachment facility commands
- DB2 commands
- CICS DB2 statistics
- Monitor CICS transactions using:
- CICS monitoring facility (CMF)
- CICS auxiliary trace
- Monitor DB2 using:
- DB2 statistics records
- DB2 accounting records
- DB2 performance records
- Monitor the CICS system (for example, the dispatcher) with CICS statistics. See Monitoring the CICS system in a CICS DB2 environment.