Monitoring CICS transactions that access DB2 resources

CICS® provides accounting and monitoring facilities for the resources required by CICS transactions in the CICS address space.

About this task

These CICS accounting and monitoring facilities can produce three types of records:
  • Performance records that record the resources used by each transaction in the CICS address space.
  • Transaction resource data to record additional information about individual resources accessed by a transaction
  • Exception records that record shortages of resources.
The CICS performance class monitoring records include the following DB2®-related data fields, in the group DFHDATA:
DB2REQCT (180)

The total number of DB2 EXEC SQL and instrumentation facility interface (IFI) requests issued by a transaction.

DB2RDYQW (187)
The elapsed time the transaction waited for a DB2 thread to become available.
DB2CONWT (188)
The elapsed time the transaction waited for a DB2 connection to become available to use with its open TCB.

CICS monitoring is used in the CICS DB2 environment with the DB2 accounting facility, to monitor performance and to collect accounting information.

For more information about matching up CICS performance class records and DB2 accounting records, see Relating DB2 accounting records to CICS performance class records. For more information about calculating processor consumption, see Accounting for processor usage in a CICS DB2 environment.

You can use the CICS auxiliary trace facility to trace SQL calls issued by a CICS application program.

For more information about trace output by the CICS DB2 attachment facility, see Troubleshooting DB2.