DB2 accounting based fields

For each APPLID, a block of data lines is presented for the DB2® accounting records associated with the CMF performance records. This data is not present if CMFONLY is specified.

SSID
DB2 Subsystem ID (field: QWHSSSID). The values are filtered by the SSID operand.
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.

Thread Utilization
This data line is always present.
Entry
The number of DB2Entry threads used in the reporting period.
Note: Transactions associated with a DB2Entry will generally run against a DB2Entry thread. However, it is possible for a transaction to overflow to a pool thread should the number of active DB2Entry threads reach the THREADLimit number defined for the DB2Entry.
Pool
The number of Pool threads used in the reporting period.
Command
The number of Command threads used in the reporting period.
Note: Command threads are reserved by the CICS® DB2 attachment facility for issuing commands to DB2 using the DSNC transaction. When the demand is great, commands overflow to the pool, and use a pool thread.

Any combination of the following DB2 data lines can be requested, or you can specify ALL to request all of them. If none are specified, the default is CLASS1, CLASS2, BUFFER, LOCKING. See the DB2 List report's DB2 accounting based fields for an explanation of these DB2 data lines:

Class1: Thread Time
Specify CLASS1 to request this line.
Class2: In-DB2 Time
Specify CLASS2 to request this line.
Class3: Suspend Time
Specify CLASS3 to request this line.
Buffer Manager Summary
Specify BUFFER to request this line.
Locking Summary
Specify LOCKING to request this line.
SQL DML Query/Update
Specify DML1 to request this line.
SQL DML 'Other'
Specify DML2 to request this line.
For each of the DB2 data lines, two values are presented:
Average
The thread average for the field.
Maximum
The maximum value of the field encountered for all threads within the reporting period. If NOMAXLONGSUM is specified, the maximum values are omitted from the report.

Total statistics are reported for each DB2 SSID and CICS APPLID.


Information Information

Feedback


Timestamp icon Last updated: Saturday, 8 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///report-reference/cparr126.htm