Monitoring using reports

You can filter the data shown in reports by using the INCLUDE and EXCLUDE subcommands to show, for example, information only for certain plans, authorization IDs, or locations. You can use the FROM and TO subcommands to filter data within specified times.

Another way to limit the data that needs to be examined is to use the TOP subcommand option to obtain a high water mark type of reporting on resource usage. The TOP lists, printed at the end of an Accounting report or trace, can identify the threads or users that have required the most use of the resources specified in the TOP subcommand option. Alternatively, you can use the TOP subcommand option with the ONLY keyword to filter entries based on resource usage and produce a report that shows only entries with the highest resource usage.

You can summarize data for certain periods by ordering your Accounting and Statistics reports by interval. For example, you can summarize data for the peak periods during the day.

If you produce SQL Activity reports and traces, potential problems can be highlighted by sorting and summarizing the information within the report and trace entries by several criteria. For example, a problem cursor can be identified by summarizing SQL activity by cursor and ordering the cursors by TCB times. The sorted entries provide an easy way to identify SQL statements that might be causing performance problems.

You can tailor your own report layouts and trace layouts with the User-Tailored Reporting feature (UTR). Use UTR to control the volume, contents, and layout of your traces and reports. The User-Tailored Reporting feature (UTR) and its use is described in detail in the Reporting User's Guide.