Resolving Restrictive and Advisory States

DB2 sets a restrictive or advisory status on an object to control access and help ensure data integrity. The following list outlines the restrictive and nonrestrictive 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. Following is an example of this command to display those objects that are in a restrictive state:

 -DISPLAY DATABASE(DBASE1) SPACE(*) RESTRICT 

Output for objects in a restrictive state is shown next:

 DSNT360I  +DSN8 *********************************** DSNT361I  +DSN8 *  DISPLAY DATABASE SUMMARY                 *    RESTRICTED DSNT360I  +DSN8 *********************************** DSNT362I  +DSN8     DATABASE = DBASE1  STATUS = RW                      DBD LENGTH = 4028 DSNT397I  +DSN8 NAME     TYPE PART  STATUS            PHYERRLO PHYERRHI CATALOG  PIECE -------- ---- ----- ----------------- -------- -------- -------- ----- TS001    TS         RW,RESTP ******* DISPLAY OF DATABASE DBASE1  ENDED      ********************** DSN9022I  +DSN8 DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION 

The -DISPLAY DATABASE command can also be used to display objects in an advisory state:

 -DISPLAY DATABASE(DBASE1) SPACE(*) ADVISORY 

Output for objects in an advisory state is as follows:

 DSNT360I  +DSN8 *********************************** DSNT361I  +DSN8 *  DISPLAY DATABASE SUMMARY                 *    ADVISORY DSNT360I  +DSN8 *********************************** DSNT362I  +DSN8     DATABASE = DBASE1  STATUS = RW                      DBD LENGTH = 4028 DSNT397I  +DSN8 NAME     TYPE PART  STATUS            PHYERRLO PHYERRHI CATALOG  PIECE -------- ---- ----- ----------------- -------- -------- -------- ----- TS002    TS         RW,ICOPY ******* DISPLAY OF DATABASE DBASE1  ENDED ********************** DSN9022I  +DSN8 DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION 

Some options find objects that are in a particular status. The following output shows objects in LPL status:

 DSNT360I  +DSN8 *********************************** DSNT361I  +DSN8 *  DISPLAY DATABASE SUMMARY                 *    GLOBAL LPL DSNT360I  +DSN8 *********************************** DSNT362I  +DSN8     DATABASE = DBASE1  STATUS = RW                      DBD LENGTH = 4028 DSNT397I  +DSN8 NAME     TYPE PART  STATUS            LPL PAGES -------- ---- ----- ----------------- ------------------ TS002    TS         RW                000039-00003C ******* DISPLAY OF DATABASE DBASE1  ENDED  ********************** DSN9022I  +DSN8 DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION 

Table 7-2 shows all the restrictive and advisory states, the objects affected, and what corrective actions need to be taken.

Table 7-2. Restrictive and Advisory States

Status Code	Status Name	Objects Affected	Corrective Action(s)
ACHKP	Auxiliary CHECK Pending	Base table space, LOB table spaces	Update or delete invalid LOB, using SQL. Run the CHECK DATA utility to verify the validity of LOBs.
AUXW	Auxiliary Warning	Base table space	Update or delete invalid LOBs, using SQL. Run the CHECK DATA utility to verify the validity of LOBs.
		LOB table space	Update or delete invalid LOBs, using SQL. Run the CHECK LOB utility to verify the validity of the LOB.
CHKP	CHECK Pending	Table space, base table space	Check and correct RI constraints, using the CHECK DATA utility.
		Partitioned index, nonpartitioned index, index on auxiliary table	Run CHECK INDEX on index. If errors, run REBUILD INDEX utility.
		LOB table space	Use the CHECK LOB utility. If errors: Correct defects found in LOB table space with the REPAIR utility. Run CHECK LOB again.
COPY	Copy Pending	Table space, table space partition	Take an image copy (best action), or use START DATABASE (db) SPACENAM(ts) ACCESS FORCE, or run REPAIR and reset COPY flag.
GRECP	GBP Recover Pending	Table space, index space	RECOVER the object, or use START DATABASE command
ICOPY	Informational COPY Pending	Partitioned index, nonpartitioned index, index on auxiliary table	Copy the affected index.
LPL	Logical Page List	Table spaces, index space	START DATABASE ACCESS R/W or R/O. Run RECOVER or REBUILD INDEX utility. Run LOAD REPLACE. DROP the object.
RBDP	REBUILD Pending	Physical or logical index partition	Run the REBUILD or RECOVER utility on the affected index partition.
RBDP*		Logical partitions of nonpartitioned secondary indexes	Run REBUILD INDEX PART or RECOVER utility on the affected logical partitions.
PSRBD		Nonpartitioned secondary index, index on the auxiliary table	Run REBUILD INDEX ALL, the RECOVER utility, or run REBUILD INDEX.
			The following actions also reset the REBUILD status: LOAD REPLACE with table space or partition. REPAIR SET INDEX with NORBDPEND on index part; however, does not correct inconsistencies. Start database ACCESS FORCE; however, does not correct inconsistencies. Run REORG INDEX SORTDATA on index.
RECP	RECOVER Pending	Table space	Run the RECOVER utility on the affected object.
		Table space partition	Recover the logical partition.
		Index on the auxiliary table	Run REBUILD INDEX, RECOVER INDEX, or REORG SORTDATA.
		Index space	Run one of the following utilities on the affected index space: REBUILD INDEX RECOVER INDEX REORG INDEX SORTDATA
		Any	The following actions also reset the RECOVER status: LOAD REPLACE with table space or partition. REPAIR SET TABLESPACE or INDEX with NORCVRPEND on index part; however, does not correct inconsistencies. Start database ACCESS FORCE; however, does not correct inconsistencies.
REFP	Refresh pending	Table space or index space	Run a LOAD REPLACE. Object will also be in RECP or RBDP status and will need appropriate action taken.
REORP	REORG Pending	Table space	Perform one of the following: LOAD REPLACE entire table space REORG TABLESPACE SHRLEVEL NONE REORG TABLESPACE PART n:m SHRLEVEL NONE
		Partitioned table space	Rows <= 32KB Run REORG TABLESPACE SHRLEVEL NONE SORTDATA Rows > 32KB Run REORG TABLESPACE UNLOAD ONLY Run LOAD TABLESPACE FORMAT UNLOAD
AREO*	Advisory REORG	Table space	Run one of the following utilities: REORG TABLESPACE LOAD REPLACE REPAIR TABLESPACE
		Index space	Run one of the following utilities: REORG TABLESPACE LOAD REPLACE REORG INDEX REPAIR INDEX
RESTP	Restart Pending	Table space, partitions, index spaces, physical index partitions	Objects are unavailable until back-out work is complete or until restart is canceled and a conditional restart or cold start is performed.
WEPR	Write Error Page Range	Page range in error	Run a RECOVER utility on affected data.