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.