Subcommands and subcommand options

You can use subcommands and subcommand options to specify how you want the data to be presented.

For details on how to specify commands refer to the Report Command Reference.

REPORT

Use this subcommand to generate reports. In reports, data is summarized by OMEGAMON for Db2 Performance Expert identifiers, such as the primary authorization ID or the plan name.

Use the LAYOUT or LEVEL subcommand options of REPORT as appropriate to specify the amount of detail you want in the report. Use the ORDER subcommand option to specify how you want the data to be summarized. Use the EXCEPTION subcommand option to produce reports that contain only values outside user-specified limits.

TRACE

Use this subcommand to produce listings that show individual DB2 events, usually in the order of occurrence.

Use the LAYOUT or LEVEL subcommand option of TRACE as appropriate to specify the amount of detail you want in the trace. Use the EXCEPTION subcommand option to produce traces that contain only values outside user-specified limits.

FILE

Use this subcommand to store data about individual DB2 events in data sets that can be used with the DB2 load utility.

Use the EXCEPTION subcommand option to produce data sets that contain only values outside user-specified limits.

REDUCE

Use this subcommand to aggregate Statistics and Accounting DB2 events. REDUCE consolidates DB2 events with the same OMEGAMON for Db2 Performance Expert identifiers. You can save the reduced data by using the SAVE command.

Use the INTERVAL and BOUNDARY subcommand options of REDUCE to specify how the data is consolidated. INTERVAL specifies the time range at which records are consolidated. BOUNDARY specifies the start time of the INTERVAL.

If SAVE or processing by INTERVAL is not required, you can omit REDUCE.

SAVE

You can save data sets as follows:

Without CONVERT option: Saves reduced data into a VSAM data set. You can use the saved data in later reporting.
You can also convert the data set into a sequential data set that can be loaded into Db2 tables using the Save-File utility.
With CONVERT option: Converts and saves reduced data into a sequential data set that can be loaded into Db2 tables.

RESTORE

Use this subcommand to include previously saved data from the VSAM data set.