Statistics values

Most of the Db2® Statistics values accumulate while Db2 is active. When Db2 is started, accumulation begins and continues until Db2 is stopped. There are, however, certain fields that are not cumulative.

Some are reported as snapshot values (gauge values in a workgroup environment), and some are reported as high-water mark values. A snapshot value is a current value. It is updated each time the Statistics values are displayed. A high-water mark is the highest value reached since startup. It is updated each time the Statistics values are displayed.

Figure 1. Snapshots and high-water marks
Snapshots and high-water marks

The values in fields other than snapshot or high-water mark fields are accumulated or delta values. They are calculated by the Statistics display and derived differently for each of the Statistics processing modes.