Interpreting the Statistics trace report and applying rules of thumb

You can use the Statistics trace report that you have produced in the previous steps for a quick assessment of the performance of your Db2 system.

A good way of looking at the data is to focus on a few key indicators and apply a few simple rules and ratios, known as rules of thumb (ROTs). Rules of thumb have been assembled by DB2 experts in the field over many years and are proven to be valuable criteria to measure the performance of applications in a Db2 system.

Rules of thumb (ROTs) are also implemented as samples in the Performance Warehouse. You can examine the ROT definitions and use the Performance Warehouse to evaluate your Db2 systems. For more information, see Monitoring Performance from Performance Expert Client.