Using Statistics traces to get system overview information

The best way to get started with OMEGAMON® XE for Db2 PE is to create a long Statistics trace report to get an overview of your Db2 system.

To do this:

  • Run a Db2 trace to collect DB2 Statistics data during a 24-hour period.
  • Create a Statistics trace report.
  • Interpret the report and adjust the system.

The reason for creating a trace report is that the 24-hour period is reported as a single interval. A normal report creates a record for each Statistics interval, which could result in an output of more than 1 200 pages.

Choose a day that will have a fairly typical workload, not a weekend, for example, or a public holiday when workload will probably be much reduced.