Selection keywords

PLAN=[plan name]

(optional) The plan name can be used to qualify which records are displayed or summarized. Up to 50 plans can be entered enclosed in parentheses and separated by commas. Simple names or qualified names can be entered in any combination.

Default is to select all records.

DB2PKG=[package name]

(optional) Package name can be used to qualify which records are displayed or summarized. Up to 50 packages can be entered enclosed in parentheses and separated by commas. Simple names or qualified names can be entered in any combination.

Default is to select all records.

AUTHID=[id]

(optional) Authorization ID can be used to qualify which records are displayed or summarized. Up to 50 authorization IDs can be entered enclosed in parentheses and separated by commas. Simple names or qualified names can be entered in any combination.

Default is to select all records.

CONNECT=[connection name]

(optional) Connection name can be used to qualify which records are displayed or summarized. Up to 50 connection names can be entered enclosed in parentheses and separated by commas. Simple names or qualified names can be entered in any combination.

Default is to select all records.

CORR=[correlation id]

(optional) Correlation ID can be used to qualify which records are displayed or summarized. Up to 50 correlation IDs can be entered enclosed in parentheses and separated by commas. Simple names or qualified names can be entered in any combination.

Default is to select all records.

LOC=[location id]

(optional) Location ID can be used to qualify which records are displayed or summarized. Up to 10 location IDs can be entered enclosed in parentheses and separated by commas. Simple names or qualified names can be entered in any combination.

Default is to select all records.

DATE=[ddmmmyyyy|ddmmmyyyy-ddmmmyyyy]

(optional) Date value is used to select a date range or starting date from the input. The input can be a single date in ddmmmyy format, which defines a starting day, or as a range in the form ddmmmyyyy-ddmmmyyyy to define starting and ending dates to process.

The asterisk is used to specify current date. To select all entries from yesterday, specify DATE=*_1

The underscore is used instead of a dash because the dash is already being used to define a range of dates. Using *-1 would result in interpreting the date as a range from current date to day 1 (which is invalid as a date).

To process only one day, specify 15AUG2008-15AUG2008

Default is to select all records.

TIME=[hhmm|hhmm-hhmm

(optional) Time value is used to select a starting time or a time range for the input:

• To select records starting at noon, specify TIME=1200.
• To select records from first shift operations only, specify TIME=0800-1559.
• To select records up to 4:00 P.M., specify TIME=-1600
• To select records for a 24-hour period on the same day, specify TIME=0000-2359 or TIME=0001-2400.
• Default is to select all records.

BP=[BPnn]

(optional) Buffer pool ID can be used to qualify which I/O event records are displayed and summarized in the DBIOx displays. Any number of buffer pool IDs can be entered, enclosed in parentheses and separated by commas.

Default is to select all I/O event records.