Default language.

Start DB2 Trace Request panel


The initial Start Db2 Trace Request panel displays a default request for a summary trace, as shown in the TYPE field of the following figure:


                             Start DB2 Trace Request
  COMMAND ===>                                              SCROLL ===> PAGE  
                                                                             
                                                            Target DEEH       
  Trace Attributes:                                                           
  PARM             (Trace Identifier)     START          (hh:mm:ss)           
  TYPE    S        (S-Summary,D-Detail)   STOP           (hh:mm/mins)         
                                                                             
  STORAGE 1000K    (Display Buffer Size)  WRAP  YES      (Y/N wrap buffer)    
  LOGTRAC Y        (Y/N log trace)        RST   HOT      (HOT,PUR,QIS)        
                                                                             
  TITLE   Db2 APPLICATION TRACE                                               
                                                                             
  Specify additional trace options: (*-processed)                             
   Selection Criteria           N  (Y/N)                                      
   Exception Filters            N  (Y/N)                                      
   Detail Trace Options         N  (Y/N)                                      
   Trace Log Data Set Options   N  (Y/N)                                      
                                                                             
   Additional Trace Targets     N  (Y/N)   Context

The Start Db2 Trace Request panel provides access to the following panels which you can use to perform the following tasks, overriding default settings such as:

Panel

Task

Selection criteria

Select the threads to be traced.

Exception filters 

Reduce the amount of data saved.

Detail trace options

Trace additional events.

Trace log data set options

Specify additional data set allocation and processing options.

Additional trace targets

Start the same trace for multiple targets.


The following table describes the trace request keywords:


Keyword

Description

id

To run multiple trace requests, specify an ID in the PARM field to make the trace unique. The identifier is used to specify which set of trace data to display with the application trace services.

Warning

Important

We recommend not using a blank as an identifier for one trace.

S | D

S (the default) requests a summary application trace of completed transactions. D requests a detail application trace that also collects major events in the life of the transaction.

n


Warning

Important

In Windows mode, Display storage is managed by . The STORAGE keyword is not used.

For full-screen trace displays, this value determines the size of the online trace display buffer to contain the trace entries per active trace. The size is specified in K format, where KB is the number of 1024 byte blocks. For example, 200KB is

200*1024=204800 bytes

This value is primed from the default specified in DMRBEXxx. If you do not specify a value, the value from BBIISPxx is used.

For a detail trace, this value must be at least four times TRSIZE value. Otherwise, it is adjusted up to the maximum of 16,383 KB.

N | Y

This value specifies whether to write all trace records for this request to a unique trace log data set (TLDS) for this trace. If you specify Y with no additional summary or detail trace logging options, a single data set is allocated dynamically with the defaults specified in DMRBEXxx for this Db2 subsystem.

Warning

Important

The BBI-SS PAS started task user ID must be authorized to use dynamic allocation.

c...c

This value defines a title for the trace (1 to 24 characters). If you are logging the trace, we recommend that you specify a more specific title to help identify the contents of this trace later.

Warning

Important

  • Special characters are not valid.
  • Only blanks are valid as separators.

hh:mm:ss

This value requests trace start time. If the time specified is more than 10 minutes prior to the current time, 24 hours are added to the specified time and the request is started the next day. To start a request at midnight, specify 24:00:00.

The default is the next full minute.

nnn | hh:mm:ss

This value requests trace stop limit as a timestamp or number of minutes to process. The default is set from the TRTIME value in DMRBEXxx.

Processing ends at the end of the last interval before the specified stop time. This time is displayed in the STOP field when the request is viewed with the R, P, M, and W line commands from the CT view.

Y | N

The buffer is used in a wraparound method to store the entries. The wrap can be automatic, WRAP=Y (default), or user-controlled, (WRAP=N).

Warning

Important

When online buffer (STORAGE) fills and no further trace records are recorded in case of setting WRAP=N for a detail trace, the trace will remain active until it is stopped or purged and not all detail records will be available. Therefore, we recommend to set WRAP=Y for all detail traces.

HOT | PUR | QIS

This value defines the restart option to be used when a service is quiesced because of an inactive Db2 subsystem or BLK=RRR (restart all monitors) request, as follows:

  • HOT restarts the trace automatically without the loss of previous data.
  • PUR purges the trace automatically when the target Db2 subsystem terminates.
  • QIS keeps the trace in a quiesced state until an authorized user purges it.
Warning

Important

For dynamic or auto-connected targets, all traces are purged when the target terminates; the RST setting is ignored.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Ops Monitor for Db2 13.1