Copy-related exceptions thresholds
Use the exceptions in this category to identify conditions in which you need to copy an object, including the following conditions:
- The existing COPY is out of date because of a reorg, rebuild, or load utility
- The object data has changed significantly
- Db2 status conditions
The following table lists the copy-related exceptions:
Copy-related exceptions
Condition | Exception definition name | Use this exception to accomplish the following: |
|---|---|---|
Copy Pend (Copy pending) | COPYPEND | Initiate an image copy on table spaces in copy pending status; if you specify Partlvl Y, BMCTRIG evaluates the exception at the partition level, otherwise, BMCTRIG evaluates the exception at the object level |
Dirty Pages (IX Dirty Pages) | IXDIRTY 2 | Initiate a copy of an index based on the percentage of index pages modified since the last image copy |
Dirty Pages (TS Dirty Pages) Percentage of pages modified since the last image copy | DIRTY1 | Initiate a full image copy based on the percentage of modified pages. |
DtyIncremt Percentage of dirty pages | DIRTYIC1 | (with the DIRTY exception) Initiate an incremental copy on objects based on the percentage of modified pages |
Full Copy Age Number of days since the last full image copy | FICAGE1 | Initiate a full image copy of this object (evaluated at the partition level) |
ICOPY pending Informational copy pending | ICPYPEND | Initiate an image copy on tablespaces or indexes in informational copy pending stats If you specify Partlvl Y, BMCTRIG evaluates the exception at the partition level. Otherwise, BMCTRIG evaluates the exception at the object level |
Image Copy Age (IX Copy Age) | IXICAGE1 | Initiate a copy of an index based on the number of days since the last image copy of this object (evaluated at the partition level) |
Image Copy Age (TS Copy Age) Number of days since the last image copy | COPYAGE1 | Initiate a full or an incremental image copy of this object if a copy has not been taken in more than the specified number of days (evaluated at the partition level) |
Load after copy | LOADCOPY2 | Identify table spaces or indexes in which there has been a LOAD REPLACE after the last copy (evaluated at the partition level) |
Mods since copy Percentage of rows that have changed since last copy | COPYMODS2 | Identify the percentage of rows or keys that have been modified since the last copy was made (evaluated at the partition level) |
No RTS copy data Object for which no DB2 RTS image copy statistics are detected. | NORTSCPY2 | Identify objects for which no Db2 RTS image copy statistics exist (evaluated at the partition level) |
NumIncremt Number of incremental copies since the last full copy | COPY#IIC | Initiate a full image copy when you have made a specific number of incremental copies or more |
Rebd after copy | REBDCOPY2 | Initiate a copy of an index based on whether a REBUILD occurred after the last copy |
Reorg after copy | REORCOPY2 | Initiate a copy of a table space or index in which there has been a REORG after the last copy (evaluated at the partition level) |
1 You can evaluate this exception using Db2 RTS or BMC statistics. Specify Db2 RTS Y or O in the exception options panel for BMCTRIG to evaluate the exception using Db2 RTS data. For more information, see Exception-data-source-groupings.
2 Specify Db2 RTS Y or O in the exception options panel (to indicate that you want to use Db2 real time statistics for analysis) to have this exception evaluated.
Related topic