COPY-pending status

The COPY-pending (COPY) restrictive status indicates that the affected object must be copied.

DB2® ignores informational referential integrity constraints and does not set CHECK-pending status for them.

Refer to the following table for information about resetting the COPY-pending status. This table lists the status name, abbreviation, affected objects, and any corrective actions.

Table 1. Resetting COPY-pending status
Status Abbreviation Object affected Corrective action Notes
COPY-pending COPY Table space, table space partition Take an image copy of the affected object.