Clearing the informational COPY-pending status (ICOPY)

If you update a table space that is defined with the NOT LOGGED attribute, the table space is put in informational COPY-pending status (ICOPY).

Procedure

To clear the ICOPY status:

  1. First, use the DISPLAY DATABASE ADVISORY command to display the ICOPY status for table spaces.
    For example:
    DSNT36I1 - * DISPLAY DATABASE SUMMARY
                   * ADVISORY
         DSNT360I - *************************************
         DSNT362I -  DATABASE = DBIQUA01 STATUS = RW
                     DBD LENGTH = 8066
         DSNT397I -
         NAME     TYPE PART STATUS       HYERRLO PHYERRHI CATALOG PIECE
         -------- ---- ---- ------------ ------- -------- ------- -----
         TPIQUQ01 TS     001 RW,AUXW
         TPIQUQ01 TS     002 RW,AUXW
         TPIQUQ01 TS     003 RW,AUXW
         TPIQUQ01 TS     004 RW,ICOPY
  2. To clear the ICOPY status, you must take a full image copy of the table space.