Resolving Restrictive and Advisory States
DB2 sets a restrictive or advisory status on an object to control access and help ensure data integrity. The list below outlines the restrictive and non-restrictive object states that affect utilities, and the steps required to correct each status for a particular object.
Use the -DISPLAY DATABASE command to display the current status for an object. Below is Table 7.1 that shows all the restrictive states, the objects affected, and what corrective actions need to be taken.
| Status Code | Status Name | Objects Affected | Corrective Action(s) |
|---|---|---|---|
| ACHKP | Auxiliary CHECK Pending | Base table space, LOB table spaces | 1. Update or delete invalid LOB using SQL 2. Run CHECK DATA utility to ... |
Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
