DB2 report

The DB2® report processes CICS® CMF performance class (SMF 110) records and DB2 accounting (SMF 101) records to produce a consolidated and detailed view of DB2 usage by your CICS systems. The DB2 report enables you to view CICS and DB2 resource usage statistics together in a single report.

The DB2 List report shows detailed information of DB2 activity for each transaction. The DB2 Summary reports summarize DB2 activity by transaction:
  • For CMF records: by APPLID/transaction/program
  • For DB2 records: by APPLID/transaction/program/SSID/plan
The reports include the following DB2 information:
  • DB2 Thread Identification, for easy cross-reference to DB2 PM
  • Class 1 Thread elapsed and CPU times
  • Class 2 In-DB2 elapsed and CPU times
  • Class 3 Suspend times
  • Buffer Manager statistics
  • Locking statistics
  • SQL DML statistics

A Recap report showing processing statistics is always printed at the end.