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.