Monitoring CICS transactions that access DB2 resources

CICS® provides accounting and monitoring facilities for the resources needed by CICS transactions within the CICS address space. Three types of records can be produced:

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)
When CICS is connected to DB2 Version 5 or earlier, the elapsed time the transaction waited for a CICS DB2 subtask to become available; or, when CICS is connected to DB2 Version 6 or later, the elapsed time the transaction waited for a DB2 connection to become available to use with its open TCB.
DB2WAIT (189)
The elapsed time the transaction waited for DB2 to service the DB2 requests issued by the transaction. When CICS is connected to DB2 Version 6 or later, this figure does not apply and is zero.

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 Problem determination for CICS DB2.

Related concepts
Accounting and monitoring in a CICS DB2 environment
Monitoring the CICS DB2 attachment facility
Monitoring DB2 when used with CICS
Monitoring the CICS system in a CICS DB2 environment
Accounting in a CICS DB2 environment: Overview

Related references
Performance data in group DFHDATA
[[ Contents Previous Page | Next Page Index ]]