Interpreting CICS DB2 statistics

In addition to the limited statistics output by the DSNC DISP STAT command and those output to the STATSQUEUE destination of the DB2CONN during attachment facility shutdown, a more comprehensive set of CICS® DB2® statistics can be collected using standard CICS statistics interfaces:
  • The EXEC CICS EXTRACT STATISTICS command accepts the DB2CONN keyword to allow CICS DB2 global statistics to be collected. CICS DB2 global statistics are mapped by the DFHD2GDS DSECT.
  • The EXEC CICS EXTRACT STATISTICS command accepts the DB2ENTRY() keyword to allow CICS DB2 resource statistics to be collected for a particular DB2ENTRY. CICS DB2 resource statistics are mapped by the DFHD2RDS DSECT.
  • The EXEC CICS PERFORM STATISTICS command accepts the DB2 keyword to allow the user to request that CICS DB2 global and resource statistics are written out to SMF.

The CICS DB2 global and resource statistics are described in the CICS statistics tables, CICS DB2 statistics. For more information about CICS and DB2, see Overview of the CICS DB2 interface. Database management for performance deals with CICS DB2 performance.