DB2 accounting based fields
- SSID
- DB2® Subsystem ID (field: QWHSSSID).
- Planname
- Plan name (field: QWHCPLAN). Note that there might be multiple plans associated with a Tran/Program if Dynamic Plan Selection or Dynamic Plan Switching is used, or if an application is modified within the reporting period.
- #Threads
- The number of threads summarized where DB2 data has been included for the given plan.
This gives the total number of matched DB2 threads used (for this APPLID/transaction/program and SSID/plan) in the reporting period. For simple transactions with default performance monitoring and ACCOUNTREC(TASK), this total would be expected to be equal to the #Tasks. Where a transaction has multiple UOWs however, the total number of threads used can be greater than the #Tasks, depending on thread reuse.
- Average Elapsed Thread Time
- Average elapsed time covered by the DB2 accounting period. included for the given plan.
- Average Elapsed In-DB2 Time
- Average In-DB2 elapsed time. This field is only available when Class 2 data is present.
- Average CPU Time: Thread
- Average CPU time accumulated for the CICS-DB2 thread.
- Average CPU Time: In-DB2
- Average In-DB2 CPU time used, derived from the accumulated TCB time. This field is only available when Class 2 data is present.
- Average Count: GetPage
- Average task Get Page request count.
- Average Count: SysPgUpd
- Average task system page (buffer) update count.
Total statistics are reported for each DB2 SSID and CICS® APPLID.