Resolving Restrictive and Advisory States

ACHKP

Auxiliary CHECK Pending

Base table space, LOB table spaces

1. Update or delete invalid LOB, using SQL.

2. Run the CHECK DATA utility to verify the validity of LOBs.

AUXW

Auxiliary Warning

Base table space

1. Update or delete invalid LOBs, using SQL.

2. Run the CHECK DATA utility to verify the validity of LOBs.

LOB table space

1. Update or delete invalid LOBs, using SQL.

2. 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

1. Run CHECK INDEX on index.

2. If errors, run REBUILD INDEX utility.

LOB table space

Use the CHECK LOB utility. If errors:

1. Correct defects found in LOB table space with the REPAIR utility.

2. 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

1. Run REORG TABLESPACE SHRLEVEL NONE SORTDATA Rows > 32KB

2. Run REORG TABLESPACE UNLOAD ONLY

3. 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.