Statistics-related exceptions and miscellaneous exceptions
The exceptions in this category can be used to identify conditions that indicate the need to collect statistics and potentially update the Db2 catalog for an object. This includes situations where the following conditions apply:
- The existing statistics are out of date due to a reorg, load, rebuild, or copy of an object.
- The object data has changed significantly.
Miscellaneous exceptions are also shown in this table.
Statistics-related exceptions and miscellaneous exceptions
Panel field name and Syntax command | Applies to | Definition | Evaluated through | Exception is true if | |||
|---|---|---|---|---|---|---|---|
TS | IX | RTS | BMC | Other | |||
Reorg after stats REORGAFTERSTATS | X | X | Whether to evaluate table spaces or indexes in which there has been a REORG since the last time statistics were updated | X | NA | NA | (Table and index partition calculation) (JULIAN_DAY (REORGRLASTTIME) > JULIAN_DAYSTATSLASTTIME)) |
Load after stats LOADAFTERSTATS | X | X | Whether to evaluate table spaces or indexes in which there has been a LOAD REPLACE since the last time statistics were collected | X | NA | NA | (Table and index partition calculation) (JULIAN_DAY (LOADRLASTTIME) > JULIAN_DAY (STATSLASTTIME)) |
Mods since stats STATSMODS | X | X | Percentage of rows or keys modified since the last statistics collection | X | NA | NA | (Table partition calculation) (((STATSINSERTS + STATSDELETES + STATSUPDATES) *100) / TOTALROWS) >= value specified (Index partition calculation) (((STATSINSERTS + STATSDELETES) * 100) / TOTALENTRIES) >= value specified |
Mass del stats STATSMASSDEL | X | X | Whether to evaluate table spaces or indexes in which there has been mass deletion since the last STATS | X | NA | NA | (Table and index partition calculation) STATSMASSDELETE IS NOT NULL AND STATSMASSDELETE > 0 |
No RTS statistics data NORTSSTATS | X | X | Raises an exception if there are no DB2RTS copy statistics | X | NA | NA | STATSLASTTIME IS NULL |
Rebd after stats REBDAFTERSTATS | NA | X | Evaluate whether there has been a REBUILD after the last time statistics were collected | X | NA | NA | JULIAN_DAY (REBUILDLASTTIME) > JULIAN_DAY (STATSLASTTIME) |
Catalog Upd Age CATSTATAGE | X | X | Number of days since statistics were saved in the Db2 catalog for this object | X | NA | X | (Table and index partition calculation) (DB2RTS N) DAYS (current date - STATSTIME) >= value specified (DB2RTS Y/O) DAYS(current date - STATSLASTTIME) >= value specified |
Nostats NOSTATS | X | X | No BMCSTATS entries were found. This option is evaluated at the partition level if you specify PARTLVL Y; otherwise, it evaluated at the object level. | NA | X | NA | The exception is true when no statistics exist in the DASD MANAGER PLUS repository. |
BMCSTATS Age BMCSTATAGE | X | X | Number of days since the last set of statistics were collected and saved in the DASD MANAGER PLUS statistics tables for this object | NA | X | NA | DAYS (current date - TIMESTMP) >= value specified |
NONUNIFORM NONUNIFORM | NA | X | Percentage of rows for a frequently occurring value of the first column of an index | NA | X | NA | FREQUENCYF * 100 >= value specified |
ROWS/KEYS ROWS/KEY | NA | X | Average number of rows per key | NA | X | NA | CARDF / FULLKEYCARD >= value specified |
CHKP Pending CHECKPEND | X | X | Table spaces or index partitions for which the informational copy pending flag is on | NA | NA | X | table space or index is in an CHECK-pending status (CHKP) |
ACHKP pending AUXCHECKPEND | X | NA | Table space partitions which the auxiliary check pending flag is on | NA | NA | X | Table space is in an auxiliary CHECK-pending status (ACHKP) |
RBDP pending REBUILDPEND | NA | X | Index partitions which the rebuild pending flag is on | NA | NA | X | Index is in a rebuild REBUILD-pending status (RBDP) |
Related topics