Copy-related exceptions
You can use exceptions in this category to identify conditions that indicate the need to copy an object. This includes situations where the existing copy is of date because of:
- A reorg utility
- A rebuild utility
- A load utility
- Situations where the object data has changed significantly
- Db2 status conditions
The following table lists the copy-related exceptions.
Copy-related exceptions
Panel field name and Syntax command | Applies to | Definition | Evaluated through | Exception is true if | |||
|---|---|---|---|---|---|---|---|
TS | IX | RTS | BMC | Other | |||
Reorg after copy REORGAFTERCOPY | X | X | Evaluate whether there has been a REORG after the last copy | X | NA | NA | (Table and index partition calculation) (JULIAN_DAY (REORGRLASTTIME) > JULIAN_DAY (COPYLASTTIME)) |
Load after copy LOADAFTERCOPY | X | X | Evaluate whether there has been a LOAD REPLACE after the last copy | X | NA | NA | (Table and index partition calculation) (JULIAN_DAY (LOADRLASTTIME) > JULIAN_DAY (COPYLASTTIME)) |
Mods since copy COPYMODS | X | X | Percentage of rows or keys modified since the last copy was made | X | NA | NA | (Table and index partition calculation) ((COPYCHANGES * 100) / TOTALROWS) > value specified (Index partition calculation) ((COPYCHANGES * 100) / TOTALENTRIES) > value specified |
No RTS copy data NORTSCOPY | X | X | Raises an exception if there are no DB2RTS copy statistics | X | NA | NA | (Table and index partition calculation) COPYLASTTIME IS NULL |
Rebd after copy REBDAFTERCOPY | NA | X | Evaluate whether there has been a REBUILD after the last copy | X | NA | NA | JULIAN_DAY (REBUILDLASTTIME) > JULIAN_DAY (COPYLASTTIME) |
Dirty Pages (IX Dirty Pages) IXDIRTY | NA | X | Percentage of index pages modified since the last image copy IXDIRTY 0 triggers an exception on one or more dirty index pages. | X | NA | NA | ((COPYUPDATEDPAGES * 100) / NACTIVE) >= percent value specified |
Copy Pend COPYPEND | X | X | Table spaces or partitions for which the copy pending flag is on | NA | NA | X | Table space is in a COPY-pending status (COPY) |
Dirty Pages (TS Dirty Pages) DIRTY | X | NA | Percentage of pages modified since the last image copy DIRTY 0 triggers an exception on one or more dirty pages | X | X | NA | (DB2RTS N) (DIRTY / NACTIVE) * 100 > value specified (DB2RTS Y/O) ((COPYUPDATEDPAGES * 100) / NACTIVE) > value specified |
ICOPY pending ICOPYPEND | X | X | Table spaces or index partitions for which the informational copy pending flag is on | NA | NA | X | Table space is in a informational COPY-pending status (ICOPY) |
Image Copy Age (TS) COPYAGE | X | NA | Number of days since the last image copy of this object | X | NA | X | (DB2RTS N) DAYS(current date - date of last image copy) >= value specified (DB2RTS Y/O) DAYS(current timestamp - COPYLASTTIME) >= value specified |
Full Copy Age FULLCOPYAGE | X | NA | Number of days since the last full image copy of this object | NA | NA | X | DAYS (current date - date of last full image copy) >= value specified |
NumIncremt INCRCOPY | X | NA | Number of incremental copies since the last full copy | NA | NA | X | count of rows where ICTYPE=I and TIMESTAMP > (MAX(TIMESTAMP) where ICTYPE=F) >= value specified |
DtyIncremt DIRTYIC | X | NA | Table spaces whose percentage of dirty pages is less than or equal to the value specified for DIRTY, but greater than this value. Use DtyIncremt in conjunction with the DIRTY trigger to cause an incremental copy to be triggered. | X | X | NA | (DB2RTS N) (DIRTY / NACTIVE) * 100 <= DIRTY value specified and DIRTY / NACTIVE) * 100 > DTYINCREMT value specified (DB2RTS Y/O) ((COPYUPDATEDPAGES * 100) / NACTIVE) <= DIRTY value specified and ((COPYUPDATEDPAGES * 100) / NACTIVE) > DTYINCREMT value specified |
Image Copy Age (IX) IXCOPYAGE | NA | X | Number of days since the last image copy of this object If this field contains a value, the product automatically sets job generation option IXCOPY to Y. | X | NA | X | (DB2RTS N) DAYS(current date - date of last image copy on the index) >= value specified (DB2RTS Y/O) DAYS(current timestamp - COPYLASTTIME) >= value specified |
Related topics