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.