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.


Information Information

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//cparr129.htm