Determining performance problems

When you find that there are performance problems when you are monitoring the system, you can use several panels and reports to investigate the cause of the problems.

Problems detected in periodic exception processing
To view the past events surrounding the problem online, you can use the HISTORY command.
Problems detected in exception event processing
If you detect a problem using the online exception event processing, collect the appropriate trace data to produce Locking reports, I/O Activity reports, Audit reports, or Record Trace reports. This section describes how to proceed with specific exception events.
Problems detected in exception reports
If you use an Accounting exception report to monitor your system, produce this report using the TOP or the INTERVAL subcommand option so that you can immediately focus on potential problem areas.

Parent topic: Monitoring and tuning