DBETE status

DBETE advisory status identifies objects that need special attention. Those objects can be table spaces, table space partitions, index spaces, index partitions, or logical index partitions.

Db2 places objects in DBETE status as a result of certain DBET abends or page set access error abends during restart or RESTORE SYSTEM. The affected objects are also placed in a restrictive state (RECP, RBDP or PSRBD), so that they are required to be recovered. By placing these objects in DBETE status, Db2 can avoid outages.

To reset DBETE status, take the actions that are described in the following table.

Table 1. Resetting OBJECT error status
Status Abbreviation Object affected Corrective action
OBJECT error DBETE Table space, table space partition, index space, index partition, or logical index partition Use one of the following utilities to recover or rebuild the object:
  • RECOVER
  • LOAD with the REPLACE option
  • REBUILD

If a table space or index space that contains partitions has a status of DBETE and RECP and is also listed as being of type UN (unknown type), you can still use the utilities in the preceding list to recover or rebuild the entire space.

The DBETE status is reset when the RECP, RBDP, or PSRBD status is reset.

DBETE, RECP, RBDP, and PSRBD status can also be reset by issuing the following command:
-START DB(db name) SP(space name) ACCESS(FORCE)
However, use caution, as this method does not correct the underlying problem that caused the restrictive state to be set.

Contact IBM® Support to report the problem. Db2 log records need to be analyzed to diagnose the cause of the problem and determine further actions.