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:
The total number of DB2 EXEC SQL and instrumentation facility interface (IFI) requests issued by a transaction.
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.