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).