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
Column name | Reset value |
|---|---|
UPDATESTATSTIME | Timestamp of the reset |
STATSLASTTIME | Timestamp of the reset |
STATSINSERTS | Zero |
STATSDELETES | Zero |
STATSUPDATES | Zero |
STATSMASSDELETE | Zero |
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
Column name | Reset value |
|---|---|
UPDATESTATSTIME | Timestamp of the reset |
STATSLASTTIME | Timestamp of the reset |
STATSINSERTS | Zero |
STATSDELETES | Zero |
STATSMASSDELETE | Zero |