Advisory or restrictive states

To control access and help ensure data integrity, DB2® sets a restrictive or nonrestrictive (advisory) status on certain objects. However, you can take steps to correct each status.

Use the DISPLAY DATABASE command to display the current status for an object.

In addition to the states mentioned in this topic, the output from the DISPLAY DATABASE command might also indicate that an object is in logical page list (LPL) status. This state means that the pages that are listed in the LPL PAGES column are logically in error and are unavailable for access. DB2 writes entries for these pages in an LPL.

Auxiliary CHECK-pending status
When the auxiliary CHECK-pending status is set on a base table space, that base table space is unavailable for processing by SQL.
Auxiliary warning status
A base table space or LOB table space in the auxiliary warning status remains available for processing by SQL.
CHECK-pending status
The CHECK-pending (CHKP) restrictive status indicates that an object might be in an inconsistent state and must be checked.
COPY-pending status
The COPY-pending (COPY) restrictive status indicates that the affected object must be copied.
DBETE status
An object is a table space, table space partition, index space, index partition, or logical index partition. The DBETE status identifies the objects that need special attention by the user.
Group buffer pool RECOVER-pending status
The group buffer pool RECOVER-pending (GRECP) status is set on when a coupling facility fails with pages that were not externalized. The affected object must be recovered.
Informational COPY-pending status
The informational COPY-pending (ICOPY) advisory status indicates that the affected object should be copied.
PRO restricted status
The Persistent Read Only (PRO) restricted status indicates that read access by SQL or utilities is allowed, but all updates to the table space partition are prohibited.
REBUILD-pending status
A REBUILD-pending restrictive status indicates that the affected index or index partition is broken and must be rebuilt from the data.
RECOVER-pending status
The RECOVER-pending (RECP) restrictive status indicates that a table space or table space partition is broken and must be recovered.
REFRESH-pending status
When DB2 marks an object in refresh-pending (REFP) status, it also puts the object in RECOVER-pending (RECP) or REBUILD-pending (RBDP or PSRBD) status.
REORG-pending status
The following three REORG-pending states indicate that an object either must or should be reorganized:
Restart-pending status
If an object has backout work pending at the end of DB2 restart, the object is placed in restart-pending (RESTP) status.

Parent topic: Additional information for utilities

Related reference:

-DISPLAY DATABASE (DB2)