Statistics-related exceptions and miscellaneous exceptions
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) |