Default language.

Information
Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

Selecting a subset of trace entries


You can type the selection keywords that are listed in the following table in the parameter field.

Keyword

Description

,A | AUTHID= xxxxxxxx

Selects a subset of the trace entries by authorization ID. Specify one authorization ID, or a generic group of authorization IDs by replacing character positions with a + (one position) or an * (multiple positions).

,C | CONNECT= xxxxxxxx

Selects a subset of the trace entries by connect type. Specify one connect type (TSO, BATCH, DB2CALL, imsid, cicsjobname) or a generic group of connections by replacing character positions with a + (one position) or an * (multiple positions).

,P | PLAN= xxxxxxxx

Selects a subset of the trace entries by plan. Specify one plan or a generic group of plans by replacing character positions with a + (one position) or an * (multiple positions).

,L | LOC= xxxxxxxx

Selects a subset of the trace entries by location. Specify one location, or a generic group of locations by replacing character positions with a + (one position) or an * (multiple positions).

,R | CORRID= xxxxxxxx

Selects a subset of the trace entries by correlation ID. Specify one correlation ID, or a generic group of correlation IDs by replacing character positions with a + (one position) or an * (multiple positions).

,T | TIME= hhmm [- hhmm ]

Selects a subset of the trace entries by a start time or time period, where hhmm indicates hours and minutes. Midnight wrap is supported, where the start time is higher than the end time; for example, TIME=2000-3000. The end time stamp of an accounting record is used to assign it a time period.

,D | DAY= nn [- nn ]

Selects a subset of the trace entries by a day or range of days, where nn can be a relative number from the date of the first accounting record in the trace buffer (first date = 1, up to a maximum of 99). If a time period is selected without a DAY specification, it uses the default value of the day of the most current record in the buffer.

Warning

Note

Each keyword can be specified only once. If more than one keyword is specified, the result is ANDed.

The parameter field is filled in automatically with any of these keywords when a series of summarizations and selections are made, as demonstrated by the following examples:

  • From LTRAC, select PLAN (TSUMP - Trace Summary by Plan) to see all trace entries.
  • From TSUMP, sort by average CPU (SORT=AC) and cursor select (expand) the line for the plan with the highest average CPU. The display returns to LTRAC but shows only the trace entries for that one plan. The parameter field is filled in with PLAN= xxxxxxxx.
  • From this LTRAC subset, select AUTH (TSUMA - Trace Summary by AUTHID) to see a summary of all trace entries for this plan only. The parameter field is still filled in with PLAN= xxxxxxxx.



 

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

MainView for DB2 6.1