TL;DR Summary: Exceptions in Db2 12 provides an overview of status codes, their meanings, affected objects, and corrective actions for Db2 environments.
- Details on status codes like ACHKP and CHECKP, including corrective actions.
- Guidance for managing database exceptions and ensuring data integrity.
| Status Code | Status name | Affected objects | Corrective action(s) |
|---|---|---|---|
| ACHKP | Auxiliary CHECK pending | Base table space, LOB table space |
1. Update or delete invalid LOBs and XML objects using SQL 2. Run CHECK DATA with appropriate SCOPE option to verify the validity of LOBs and XML objects |
| AUXW | Auxiliary warning | Base table space |
1. One update or delete invalid LOBs and XML using SQL 2. If an orphan LOB or a version mismatch exists between the base table and the auxiliary index, use REPAIR to delete the LOB from the LOB table space 3. Check data to verify the validity of LOBs and XML objects |
| AUXW | Auxiliary warning | LOB table space |
1. Update or delete invalid LOBs and XML using SQL 2. If an orphan LOB or a version mismatch exists between the base table and the auxiliary index, use REPAIR to delete the LOB from the Lob table space 3. Run CHECK LOB to verify the validity of the LOBs and XML objects |
| CHECKP |
CHECK Pending |
Table space, base table space |
Check and correct RI constraints using CHECK DATA
If a tablespace is in both REORG-pending and CHECK pending (or auxiliary CHECK-pending) status, run REORD first and then use CHECK DATA |
| CHECKP |
CHECK Pending |
Partitioning index, non-partitioning index, index on auxiliary table |
1. Run CHECK INDEX on the index 2. If errors, run REBUILD INDEX |
| CHECKP |
CHECK Pending |
LOB table space |
Run CHECK LOB. If errors: 1. Correct defects found in the LOB table space with REPAIR 2. Run CHECK LOB again |
| COPY |
COPY pending |
Table space, table space partition | Take an image copy (best action), use - START DATABASE(db) SPACENAM(ts) ACCESS FORCE, or run REPAIR and reset copy flag |
| DBETE |
Database Exception table (DBET) error |
Table space, partition, index, index partition, logical index partition | Contact IBM support |
| GRECP | Group buffer pool (GBP) recover pending | Table space, index space, | RECOVER the object, or use the START DATABASE command |
| ICOPY | Informational COPY pending | Partitioned index, non-partitioned index, index on auxiliary table | Copy the affected index |
| ICOPY | Informational COPY pending | NOT LOGGED table space | Copy the affected table space |
| LPL | Logical page list | Table spaces, index space |
· START DATABASE ACCESS RA/W or R/O · Run RECOVER or REBUILD INDEX utility · Run LOAD REPLACE · DROP the object |
| PRO | Persistent Read Only | Table space partitions | |
| ARDBP | Advisory REBUILD pending | Index | Run REBUILD on affected index |
| RBDP | REBUILD pending | Physical or logical index partition | Run REBUILD or RECOVER on the affect index partition |
| RBDP* | REBUILD pending | Logical partitions of non-partitioned secondary indexes | Run REBUILD INDEX PART or RECOVER on the affected logical partitions |
| PSRBD | REBUILD pending | Non-partitioned secondary index, index on auxiliary table | Run REBUILD INDEX ALL, RECOVER or REBUILD INDEX |
| PSRBD | REBUILD pending | Non-partitioned secondary index, index on auxiliary table |
Note: The following actions also reset the REBUILD status.
· LOAD REPLACE with table space or partition · REPAIR SET INDEX with NORBDPEND on index part (however this action doesn't correct inconsistencies) · Start database ACCESS FORCE (however this action doesn't correct inconsistencies) · REORG INDEX SORTDATA on the index |
| RECP | RECOVER pending | Table space | Run the RECOVER utility on the affected object |
| Table space partition | Recover the logical partition | ||
| Index on 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 this action doesn't correct inconsistencies) · Start database ACCESS FORCE (however this action doesn't correct inconsistencies) |
||
| REFP | Refresh pending | Table space, index space | Run a LOAD REPLACE. The 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 an entire table space · REORG TABLESPACE SHRLEVEL NONE · REORD TABLESPACE PART n:m SHRLEVEL NONE · REORD TABLESPACE REFERENCE or CHANGE |
| REORP |
REORG pending |
Partitioned table space |
For rows <=32 K; Run REORG TABLESPACE SHRLEVEL NONE SORTDATA
For rows > 32 K; 1. Run REORG TABLESPACE UNLOAD ONLY 2. Run LOAD TABLESPACE FORMAT UNLOAD |
| AREO* | Advisory REORG | Table space |
Run one of the following utilities:
· REORG TABLESPACE · LOAD REPLACE · REPAIR TABLESPACE |
| AREO* | Advisory REORG | Index space |
Run one of the following utilities:
· REORG TABLESPACE · LOAD REPLACE · REORG INDEX · REPAIR INDEX |
| AREOR | Advisory REORG | Table space |
Run one of the following utilities:
· REORG TABLESPACE · REPAIR TABLESPACE |
| AREOR | Advisory REORG | Index Space |
Run one of the following utilities:
· REORG TABLESPACE · LOAD REPLACE · REBUILD INDEX · REPAIR INDEX |
| RESTP | Restart pending | Table space, partition, index space, physical index partition | Objects are unavailable until back-out work is complete or until restart is canceled and a conditional restart or cold start is performed |
| STOPE | Stop error | Table space, index space | RECOVER the tablespace or index space |
| WEPR | Write error page range | Page range in error | Run a RECOVER utility on affected data |
Disclaimer: This Db2® 12 for z/OS Reference Guide was developed to help users in their daily activities in administrating and programming in Db2 for z/OS. There are no guarantees expressed or implied with the contents in this guide. We want to provide a quality and useful reference for users. Please notify us of any mistakes or errors in this reference guide at blogs@bmc.com. Db2 is a registered trademark of the IBM Corporation.
Db2 Guide
- Db2 12 for z/OS: An Introduction
- Scalar Functions in Db2 12
- How to Read IBM<sup>®</sup> Syntax Diagrams for Db2 12
- Language Elements in Db2 12
- Aggregate Functions in Db2 12
- Table & Row Functions in Db2 12
- Queries in Db2 12
- Commands in Db2 12
- SQL Control Statements in Db2 12
- Explain Tables in Db2 12
- DSNZPARMs in Db2 12
- Bind Parameters in Db2 12
- Db2 Limits in Db2 12
- SQL Communication Area (SQLCA) in Db2 12
- REXX SQLCA in Db2 12
- Get Diagnostics in Db2 12
- IFCIDS in Db2 12
- Catalog Tables in Db2 12
- Exceptions in Db2 12
- XML Schema Repository Tables in Db2 12
- Updatable Catalog Statistics in Db2 12
- IBM Utilities in Db2 12
- SQL Positive Return Codes in Db2 12
- SQL Error Return Codes in Db2 12
These postings are my own and do not necessarily represent BMC's position, strategies, or opinion.