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 DA41 11/05/13 16:01:47   2  
> Help PF1              Back PF3              Up PF7                  Down PF8  
=============================================================================== 
>                            ACTIVE TRACE DETAIL                                
 DTRD                                                                           
+    Trace Qualifications:                                                      
+ Number   = 015   Type = AUDIT         Destination = SMF           Asid = 003A 
+ Class    = *                                                                  
+ Rmids    = 01                                                                 
+ Tdata    = CORRELATION,DISTRIBUTED                                            
+ Plan     = PTAM           Location  = LOCTAMMMMMMMMMMMMM                      
+ Authid   = ATAM           Wrkstn    = *                                       
+ Connid   = *              Appname   = APPTAM                                  
+ Corrid   = *              Userid    = TAM                                     
+ Pkgloc   = *                                                                  
+ Pkgcol   = *                                                                  
+ Pkgprog  = *                                                                  
+ Role     = L2L2L2L2L2L2L2                                                     
+ Audit Policy Names(AUDTPLCY):                                                 
+            AUDITADMN1                                                         
+            AUDITADMN2                                                         
+            AUDITADMN3                                                         
+                                                                               
+    Misc Trace Information    = None                                           
+                                                                               
+    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       = 2                                              
+                                                                               
+               IFCID    IFCID Description                                      
+               _____    ________________________________________               
+                361     ADMINISTRATIVE AUTHORITIES                             
+                362     START/STOP TRACE WITH AUDIT POLICY                     
===============================================================================

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.