DB2 accounting based fields

A block of data lines is presented for each DB2® Accounting record associated with the CMF performance record. This data is not present if CMFONLY is specified.

SSID
DB2 Subsystem ID (field: QWHSSSID). The values are filtered by the SSID operand.
Authid
Authorization ID (field: QWHCAID).
Planname
Plan name (field: QWHCPLAN).
APPLID
Connection name (field: QWHCCN, when connecting system type QWHCATYP is CICS® attach QWHCCICS).
Task
Transaction identification number which, when combined with the APPLID field, identifies the CICS task to which the DB2 Accounting data relates.
This number is derived by CICS PA:
  • If CICS PA matches the DB2 Accounting record to a single CICS task, the CMF task number is printed against the DB2 Accounting record details, otherwise the task number is N/C (cannot be calculated).
  • If this field is N/C, then either the DB2 Accounting data could not be correlated to a task, or it was found to relate to more than one task in the Network UOW. This can occur, for example, if thread reuse occurs within a Network UOW and ACCOUNTREC(TASK) is being used. CICS PA will not apportion statistics. If this field is N/C, then the DB2 data will not be included in the Summary reports.
Thread Identification:
This is always present.
Thread ID
Correlation ID value (field: QWHCCV).
CICS NETName
To correlate to DB2 PM reports.
CICS UOWID
To correlate to DB2 PM reports.
Begin Time
Begin time (hh:mm:ss.thm mm/dd/yy) of the DB2 accounting period (STCK field: QWACBSC).
End Time
End time (hh:mm:ss.thm mm/dd/yy) of the DB2 accounting period (STCK field: QWACESC).
Note: When you run the DB2 report on a system with a different time zone setting to that of the SMF data, the DB2 time stamps can be out of sync with the CMF time stamps. Every CMF record includes a time zone conversion factor. CICS PA uses this to convert the time stamps to reflect the local time of the SMF data. DB2 records, however, do not have a time zone conversion factor. CICS PA uses the reporting system's time zone. To synchronize the CMF and DB2 time stamps, specify the ZONE operand to match the time zone of the SMF data. The ZONE specification is used to convert both CMF and DB2 time stamps to local time, keeping them in sync.

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.

Class1: Thread Time
This line is present only if CLASS1 is specified.
Elapsed
Elapsed time covered by the DB2 Accounting record; derived from End Time minus Begin Time. It gives the time from when the DB2 thread is obtained (at the first SQL call) to the time it is terminated or reused by another sign-on (which might be well after the task completes if it is a protected thread).
CPU
TCB CPU time used by the thread; derived from QWACEJST minus QWACBJST.
Class2: In-DB2 Time
This is only available when DB2 Class 2 Accounting Trace data is present. This line is present only if CLASS2 is specified.
Elapsed
Accumulated elapsed time used in DB2 (field: QWACASC).
CPU
Accumulated TCB CPU time used in DB2 (field: QWACAJST).
Class3: Suspend Time
This is only available when DB2 Class 3 Accounting Trace data is present. This line is present only if CLASS3 is specified.
Total
Total Class 3 suspend time.
I/O
Accumulated elapsed I/O wait time (field: QWACAWTI).
Lock/Latch
Start of changeAccumulated total of all Local and Global lock times.
  1. Accumulated lock and latch time (field: QWACAWTL)
  2. Accumulated wait time due to global contention for parent L-locks. (field: QWACAWTJ)
  3. Accumulated wait time due to global contention for child L-locks (field: QWACAWTK)
  4. Accumulated wait time due to global contention for other L-locks (field: QWACAWTM)
  5. Accumulated wait time due to global contention for pageset/partition P-locks (field: QWACAWTN)
  6. Accumulated wait time due to global contention for page P-locks (field: QWACAWTO)
  7. Accumulated wait time due to global contention for other P-locks (field: QWACAWTQ)
End of change
Other
Total of the other Start of changeeightEnd of change Class 3 suspend clocks:
  1. Log Write I/O (field: QWACAWLG)
  2. Page Latch contention (field: QWACAWTP)
  3. Send Message to other DB2 members in the data sharing group (field: QWACAWTG)
  4. Stored Procedure waiting for available TCB (field: QWACCAST)
  5. User-defined function waiting for available TCB (field: QWACUDST)
  6. Read I/O done under another Thread (field: QWACAWTR)
  7. Write I/O done under another Thread (field: QWACAWTW)
  8. Synchronous Execution Unit Switch for DB2 Commit, Abort, or Deallocation processing (field: QWACAWTE)
Buffer Manager Summary
These fields will give the total for all buffer pools. This line is present only if BUFFER is specified.
GtPgRq
Number of Get Page requests issued (field: QBACGET).
SyPgUp
Number of system page (buffer) updates (field: QBACSWS).
Locking Summary
This line is present only if LOCKING is specified.
Suspnd
Number of suspends due to lock conflict (field: QTASLOC).
DeadLk
Number of deadlocks (field: QTXADEA).
TmeOut
Number of timeouts (field: QTXATIM).
MxPgLk
Maximum number of page locks held (field: QTXANPL).
SQL DML Query/Update
This line is present only if DML1 is specified.
Sel
Number of SELECT statements processed (field: QXSELECT).
Ins
Number of INSERT statements processed (field: QXINSRT).
Upd
Number of UPDATE statements processed (field: QXUPDTE).
Del
Number of DELETE statements processed (field: QXDELET).
SQL DML 'Other'
This line is present only if DML2 is specified.
Des
Number of DESCRIBE, DESCRIBE CURSOR, DESCRIBE INPUT, and DESCRIBE PROCEDURE statements processed (field: QXDESC).
Pre
Number of SQL PREPARE statements processed (field: QXPREP).
Ope
Number of OPEN statements processed (field: QXOPEN).
Fet
Number of FETCH statements processed (field: QXFETCH).
Clo
Number of CLOSE statements processed (field: QXCLOSE).