Updating Db2 real-time statistics

When you run BMCSTATS and specify UPDATEDB2, BMCSTATS resets the real-time statistics and timestamp values (in both the DSNRTSDB and Db2 memory). The BMCUPRS utility resets the real-time statistics and timestamp values only when you specify RESETRTS Y.

The following table lists the columns in table SYSIBM.SYSTABLESPACESTATS that BMCSTATS and BMCUPRS reset for each partition and the reset value:

Statistics reset in table SYSIBM.SYSTABLESPACESTATS

The following table lists the columns in table SYSIBM.SYSINDEXSPACESTATS that BMCSTATS and BMCUPRS reset for each partition and the reset value:

Statistics reset in table SYSIBM.SYSINDEXSPACESTATS