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
- Accumulated total of all Local and Global lock times.
- Accumulated lock and latch time (field: QWACAWTL)
- Accumulated wait time due to global contention for parent L-locks. (field: QWACAWTJ)
- Accumulated wait time due to global contention for child L-locks (field: QWACAWTK)
- Accumulated wait time due to global contention for other L-locks (field: QWACAWTM)
- Accumulated wait time due to global contention for pageset/partition P-locks (field: QWACAWTN)
- Accumulated wait time due to global contention for page P-locks (field: QWACAWTO)
- Accumulated wait time due to global contention for other P-locks (field: QWACAWTQ)
- Other
- Total of the other eight Class 3 suspend
clocks:
- Log Write I/O (field: QWACAWLG)
- Page Latch contention (field: QWACAWTP)
- Send Message to other DB2 members in the data sharing group (field: QWACAWTG)
- Stored Procedure waiting for available TCB (field: QWACCAST)
- User-defined function waiting for available TCB (field: QWACUDST)
- Read I/O done under another Thread (field: QWACAWTR)
- Write I/O done under another Thread (field: QWACAWTW)
- 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).