IFCID 147 - Monitor Detail Data
This topic shows detailed information about "Record Trace - IFCID 147 - Monitor Detail Data".
Record trace - IFCID 147 - Monitor Detail Data
The field labels shown in the following sample layout of "Record Trace - IFCID 147 - Monitor Detail Data" are described in the following section.
! MONITOR DETAIL DATA
!API BEGIN ELAPSED TIME N/P API ENDING ELAPSED TIME N/P
!API BEGIN CPU TIME 0.000000 API ENDING CPU TIME 0.000000
!API BEGIN SRB TIME N/A API ENDING SRB TIME N/A
!IFI BEGIN ELAPSED TIME N/P IFI ENDING ELAPSED TIME N/P
!IFI BEGIN CPU TIME 0.000000 IFI ENDING CPU TIME 0.000000
!BEGIN/RESUME CPU TIME 0.000000 TCB TIME BEFORE ENCLAVE N/A
!BEGIN/RESUME TOD TIME 0.000000
!LOCK - I/O - LATCH BEGIN TIME N/P LOCK - I/O - LATCH ENDING TIME N/P
!END-OF-TASK CPU TIME 0.000000 ACCOUNTING ENTRY CPU TIME 0.000000
!EU SWITCH BEGIN ELAPSED TIME N/P EU SWITCH ENDING ELAPSED TIME N/P
!ARCH LOG(QUIESCE) BEGIN TIME N/P ARCH LOG(QUIESCE) ENDING TIME N/P
!ACE TOKEN X'1AFD26A0' APPL REQUEST COUNT 3 ASCB TOKEN X'00F96780' LATCH TOKEN:N/P
!TCB TOKEN X'008FE920' AGENT ASID 181 STATUS INDICATOR 1: THREAD AT PLAN LEVEL
!CONNECTION TYPE BATCH LATEST IFCID 0 STATUS INDICATOR 2: AGENT IS NOT IN EOT TERM
!DBID 0 PREVIOUS IFCID 0 STATUS INDICATOR 3: CREATE_THREAD IS NOT QUEUED
!OBID 0 LATCH CLASS 00 TSO CONNECTION TYPE: BACKGROUND
!THREAD TYPE : N/P THREAD STATUS: IN DB2 STATUS INDICATOR 5: AGENT NOT QUEUED FOR EOT TERM
!THREAD TOKEN : X'00000818' LUWSEQ : 1 STATUS INDICATOR 6: NOT RUNNING STORED PROCEDURE
!NESTING.LVL : 0 STATUS INDICATOR 7: NOT WAITING FOR STORED PROC.
!NESTING ACTIVITY: NO NESTED ACTIVITY CONS.TOKEN: X'2020202020202020'
!NETWORKID : DEIBMIPS LUNAME: IPSAQA11 UNIQUENESS VALUE: X'D0A24DA3F33A' ENCL.TOKEN: X'0000000000000000'
!LOCATION : 'BLANK'
!COLLECTION : 'BLANK'
!PACKAGE : 'BLANK'
!STORED PROCEDURE NAME: 'BLANK'
!SCHEMA NAME : 'BLANK'
- API BEGIN ELAPSED TIME
The API begin elapsed time in the format day, hour, minute, second, and millionth of a second. If the value is 0, N/P is printed.
Field Name: QW0148AB
- API ENDING ELAPSED TIME
The API ending elapsed time in the format day, hour, minute, second, and millionth of a second. If the value is 0, N/P is printed.
Field Name: QW0148AE
- API BEGIN CPU TIME
The API beginning CPU time in the format minute, second, and millionth of a second. If the value is 0, N/P is printed.
Field Name: QW0148UB
- API ENDING CPU TIME
The API ending CPU time in the format minute, second, and millionth of a second. If the value is 0, N/P is printed.
Field Name: QW0148UE
- API BEGIN SRB TIME
The API beginning SRB time in the format minute, second, and millionth of a second. If the value is 0, N/P is printed.
Field Name: QW0148SB
- API ENDING SRB TIME
The API ending SRB time in the format minute, second, and millionth of a second. If the value is 0, N/P is printed.
Field Name: QW0148SE
- IFI BEGIN ELAPSED TIME
The IFI begin elapsed time in the format day, hour, minute, second, and millionth of a second. If the value is 0, N/P is printed.
Field Name: QW148IAB
- IFI ENDING ELAPSED TIME
The IFI ending elapsed time in the format day, hour, minute, second, and millionth of a second. If the value is 0, N/P is printed.
Field Name: QW148IAE
- IFI BEGIN CPU TIME
The IFI beginning CPU time in the format minute, second, and millionth of a second. If the value is 0, N/P is printed.
Field Name: QW148IUB
- IFI ENDING CPU TIME
The IFI ending CPU time in the format minute, second, and millionth of a second. If the value is 0, N/P is printed.
Field Name: QW148IUE
- BEGIN/RESUME CPU TIME
The start or resume CPU time for a stored procedure, user-defined function, or trigger.
Field Name: QW148ATC
- TCB TIME BEFORE ENCLAVE
The accumulated TCB time that is used when running under the control of a trigger. This does not include the time that is used while running in user-defined functions or stored procedures that are called from the trigger.
This CPU time does not include the CPU time that is consumed on an IBM specialty engine.
Field Name: QWACTRTT
This is an exception field.
- BEGIN/RESUME TOD TIME
The start or resume TOD time for a stored procedure, user-defined function, or trigger.
Field Name: QW148AOD
- LOCK - I/O - LATCH BEGIN TIME
The beginning time of the I/O including lock and latch use in the format day, hour, minute, second, and millionth of a second. If the value is 0, N/P is printed.
Field Name: QW0148LB
- LOCK - I/O - LATCH ENDING TIME
The ending time of the I/O including lock and latch use in the format day, hour, minute, second, and millionth of a second. If the value is 0, N/P is printed.
Field Name: QW0148LE
- END-OF-TASK CPU TIME
The CPU time from DSN3EOT0 in the format minute, second, and millionth of a second. If the value is 0, N/P is printed.
Field Name: QW0148EO
- ACCOUNTING ENTRY CPU TIME
The CPU time at entry to a monitoring or accounting class 2 or class 3 wait, in the format minute, second, and millionth of a second. If the value is 0, N/P is printed.
Field Name: QW0148LW
- EU SWITCH BEGIN ELAPSED TIME
The beginning of the elapsed time of the wait for the execution unit switch. If the value is 0, N/P is printed.
Field Name: QW0148EB
- EU SWITCH ENDING ELAPSED TIME
The end of the elapsed time of the wait for the execution unit switch. If the value is 0, N/P is printed.
Field Name: QW0148EE
- ARCH LOG(QUIESCE) BEGIN TIME
The beginning of the elapsed time of the wait for the ARCHIVE LOG MODE (QUIESCE) command. If the value is 0, N/P is printed.
Field Name: QW0148RB
- ARCH LOG(QUIESCE) ENDING TIME
The end of the elapsed time of the wait for the ARCHIVE LOG MODE (QUIESCE) command. The end time minus begin time should be the total time the agent is suspended due to the ARCHIVE LOG MODE (QUIESCE) command. If the value is 0, N/P is printed.
Field Name: QW0148RE
- ACE TOKEN
The hexadecimal address of the agent control element. Indicates the thread reported here. If the value is 0, N/P is printed.
Field Name: QW0148AC
- APPL REQUEST COUNT
The number of attachment facility calls to DB2.
Field Name: QW0148RQ
- ASCB TOKEN
The ASCB token in hexadecimal. If the value is 0, N/P is printed.
Field Name: QW0148MA
- LATCH TOKEN
The latch token. If the value is 0, N/P is printed.
Field Name: QW0148LA
- TCB TOKEN
The TCB token. If the value is 0, N/P is printed.
Field Name: QW0148MT
- AGENT ASID
The ASID of the thread.
Field Name: QW0148AS
- STATUS INDICATOR 1
Indicates whether the thread is at plan or signon/identify level.
Field Name: QW0148CD
- CONNECTION TYPE
The connection type.
Field Name: QW0148TY
- LATEST IFCID
The latest IFCID processed.
Field Name: QW0148IL
- STATUS INDICATOR 2
Indicates whether the agent is in end-of-task processing.
Field Name: QW0148ES
- DBID
The database ID. Deduced from the DB2 fields QW0148DB, QW0105DN or QW0107DN.
When present, the database name is shown, otherwise the decimal identifier from QW0148DB is shown, or N/A when this value is 0.
Field Name: RT0148DB
- PREVIOUS IFCID
The previous IFCID processed.
Field Name: QW0148IP
- STATUS INDICATOR 3
Indicates whether the create thread request is queued.
Field Name: QW0148CQ
- OBID
The object ID. Deduced from the DB2 fields QW0148OB, QW0105TN or QW0107TN.
If present, the name of the object is shown, otherwise the decimal identifier from QW0148OB is shown, or N/A if this value is 0.
Field Name: RT0148OB
- LATCH CLASS
The latch class in hexadecimal.
Field Name: QW0148LC
- TSO CONNECTION TYPE
The TSO connection type.
Field Name: QW0148TS
- THREAD TYPE
The type of thread being processed.
Field Name: QW0148DD
- THREAD STATUS
The status of the thread being processed.
Field Name: QW0148AI
- STATUS INDICATOR 5
Indicates whether the agent is queued for end-of-task processing.
Field Name: QW0148EQ
- THREAD TOKEN
The thread token. This token uniquely identifies a specific thread and also appears in the display thread command response.
Field Name: QW148TTK
- LUWSEQ
The LUW sequence number.
Field Name: QW0148CC
- STATUS INDICATOR 6
Indicates whether the thread is running a stored procedure in DB2.
Field Name: QW0148SN
- NESTING.LVL
Nesting level of the stored procedure, user-defined function or trigger, in the range 1 through 16.
Field Name: QW148ALV
- STATUS INDICATOR 7
Indicates whether the thread is queued waiting for a stored procedure to be scheduled.
Field Name: QW0148SQ
- NESTING ACTIVITY
Nesting activity of the stored procedure, user-define function or trigger, if any.
Field Name: QW148AFG
- CONS.TOKEN
The consistency token.
Field Name: QW0148CN
- NETWORKID
The network identifier.
Field Name: QW0148NI
- LUNAME
The logical unit name.
Field Name: QW0148LM
- UNIQUENESS VALUE
The instance number.
Field Name: QW0148UV
- ENCL.TOKEN
The enclave token, if under enclave, otherwise zero.
Field Name: QW148ETK
- LOCATION
The name of the location where the thread executes the package.
Field Name: QW0148LN
- COLLECTION
The collection name.
Field Name: QW0148CI
- PACKAGE
The package identifier.
Field Name: QW0148PN
- STORED PROCEDURE NAME
The stored procedure name.
Field Name: QW0148SP
- SCHEMA NAME
Schema name, under which a stored procedure, user-define function or trigger is executing.
Field Name: QW148SCH
- TOKEN
The consistency token.
Field Name: QW0148CN