Active Trace Detail
This panel shows Db2 trace activity at a detailed (IFCID) level. With this information you can determine how much overhead was incurred in the traces.
_________________ ZTRACED VTM O2 V550.#P XCA2 10/11/23 12:17:21 2
> Help PF1 Back PF3 Up PF7 Down PF8
================================================================================
> ACTIVE TRACE DETAIL
DTRD
+ Trace Qualifications:
+ Number = 004 Type = PERFORMANCE Asid = *
+ Dest = SMF ,GTF ,SRV ,OP4 ,OP7 ,OP8 ,OP9 ,OP10,OP11,OP12,OP14,OP15,OP16
+ Class = 01,02,03,23,24
+ Rmids = *
+ Tdata = CORRELATION,DISTRIBUTED
+ Plan = * Location = *
+ Authid = * Wrkstn = *
+ Connid = * Appname = *
+ Corrid = * Userid = *
+ Pkgloc = *
+ Pkgcol = *
+ Pkgprog = *
+ Role = *
+ Misc Trace Information = APPLICATION REQUESTING OPX USE IS NOT ACTIVE
+ BUFSIZE = 1024K
+
+ Exclude Trace Qualifications:
+ XPlan = None XLoc = None
+ XAuthid = None XWrkstn = None
+ XConnid = None XAppname = None
+ XCorrid = None XUserid = None
+ XPkgloc = None
+ XPkgcol = None
+ XPkgprog = None
+ XRole = None
+
+ Total IFCIDS Active = 69
+
+ IFCID IFCID Description
+ _____ ________________________________________
+ 001 STATISTICS DATA COLLECTION
+ 002 STATISTICS DATA COLLECTION
+ 003 ACCOUNTING DATA COLLECTION
+ 022 RECORD MINI-PLANS GENERATED
+ 031 RECORD EDM POOL FULL CONDITION
+ 042 START CHECKPOINT PROCESSING
================================================================================Navigation
For additional information about other topics, use the PF keys.
Fields
Trace Qualifications:
- Number
- The internal Db2 trace number assigned to the trace.
- Type
- The trace type.
- Destination
- The destinations that are assigned to the trace on this line.
- ASID
- Specifies the address space for which trace data is collected.
- Class
- The active trace class(es) on this trace.
- Rmids
- The resource manager IDs (Rmids) specified when the trace was started. If the trace was qualified with no Rmids, this field contains an asterisk (*).
- Tdata
- The trace headers that are in use by this trace entry.
- Plan
- The plan name qualifying the trace. If the trace was not qualified with a Plan, this field contains an asterisk (*).
- Location
- The location name qualifying the remote trace. If the trace was not qualified with a location, this field contains an asterisk (*).
- Authid
- The authorization identifier (Authid) qualifying the trace. If the trace was not qualified with an authorization identifier, this field contains an asterisk (*).
- Wrkstn
- The workstation name (Wrkstn) qualifying the trace. If the trace was not qualified with a workstation name, this field contains an asterisk (*).
- Connid
- The connection name (Connid) qualifying the trace. If the trace was not qualified with a connection name, this field contains an asterisk (*).
- Appname
- The application name (Appname) qualifying the trace. If the trace was not qualified with an application name, this field contains an asterisk (*).
- Corrid
- The correlation name (Corrid) qualifying the trace. If the trace was not qualified with a correlation name, this field contains an asterisk (*).
- Userid
- The user name (Userid) qualifying the trace. If the trace was not qualified with a user name, this field contains an asterisk (*).
- Pkgloc
- The location name of the package (Pkgloc) qualifying the trace. If the trace was not qualified with the location name of the package, this field contains an asterisk (*).
- Pkgcol
- The collection name of the package (Pkgcol) qualifying the trace. If the trace was not qualified with the collection name of the package, this field contains an asterisk (*).
- Pkgprog
- The DBRM or program name (Pkgprog) qualifying the trace. If the trace was not qualified with a DBRM or program name, this field contains an asterisk (*).
- Role
- The connection role name qualifying the trace. If the trace was not qualified with a connection role name, this field contains an asterisk (*).
- Audit Policy Names(AUDTPLCY)
- Specifies a list of up to eight audit policy names (AUDTPLCY) for which trace information is gathered.
Miscellaneous trace information: The
following fields are displayed if the Trace Destination field contains
an OPx destination.
- JOBNAME
- The jobname that started the trace.
- ASID
- The address space ID of the job that started the trace.
- PLANNAME
- The plan name of the thread that is using the OPx destination.
- AUTHID
- The authorization identifier of the thread that started the trace. For active trace requests in use by OMEGAMON® for Db2 PE, the authorization ID is that of the O2CI address space, not the authorization ID of the user issuing the start trace request.
- CONNID
- The connection ID of the thread that is using the OPx destination.
- CORRID
- The correlation ID of the thread that is using the OPx destination.
- BUFSIZE
- The buffer size value that was used when the trace was started.
Exclude Trace Qualifications:
- XPlan
- The exclude filtering for the plan name (XPlan). If the trace was not qualified with an XPlan , this field contains NONE.
- XLoc
- The exclude filtering for the location name (XLoc) qualifying the remote trace. If the trace was not qualified with an XLoc, this field contains NONE.
- XAuthid
- The exclude filtering for authorization identifier (Xauthid). If the trace was not qualified with an XAuthid, this field contains NONE.
- XWrkstn
- The exclude filtering for workstation name (XWrkstn). If the trace was not qualified with an XWrkstn, this field contains NONE.
- XConnid
- The exclude filtering for connection name (XConnid). If the trace was not qualified with an XConnid, this field contains NONE.
- XAppname
- The exclude filtering for application name (XAppname). If the trace was not qualified with an XAppname, this field contains NONE.
- XCorrid
- The exclude filtering for correlation name (XCorrid). If the trace was not qualified with an XCorrid, this field contains NONE.
- XUserid
- The exclude filtering for user name (XUserid). If the trace was not qualified with an XUserid, this field contains NONE.
- XPkgloc
- The exclude filtering for the location name of the package (XPkgloc). If the trace was not qualified with an XPkgloc, this field contains NONE.
- XPkgcol
- The exclude filtering for the collection name of the package (XPkgcol). If the trace was not qualified with an XPkgcol, this field contains NONE.
- XPkgprog
- The exclude filtering for DBRM or program name (XPkgprog). If the trace was not qualified with a XPkgprog, this field contains NONE.
- XRole
- The exclude filtering for connection role name (XRole). If the trace was not qualified with a XRole, this field contains NONE.
IFCID information:
- Total IFCIDs Active
- The total number of trace IFCIDs activated by the trace entry.
- IFCID
- The number of an active IFCID.
- IFCID Description
- The description of the IFCID on this line.