Advisory or restrictive states

To control access and help ensure data integrity, Db2 can set 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.

Important: If you need to remove a restrictive state without correcting the problem, you can use the REPAIR utility with the SET statement or start the database with ACCESS(FORCE). However, use these options with caution, as they do not correct the underlying problem that caused the object to be placed in the restrictive state.