DBETE status

Start of changeAn object is a table space, table space partition, index space, index partition, or logical index partition.End of change The DBETE status identifies the objects that need special attention by the user.

Start of changeTo reduce outages caused by certain DBET abends or page set access error abends during restart or RESTORE SYSTEM, DB2® tolerates such abends and puts objects into advisory status DBETE, as well as a restrictive exception status that requires objects to be recovered. Depending on the type of object, either a table space or an index space, the restrictive exception status can be RECP, RBDP, or PSRBD.End of change

Refer to the following table for information about resetting the error status. This table lists the status name, abbreviation, affected objects, and any corrective actions.

Start of change
Table 1. Resetting OBJECT error status
Status Abbreviation Object affected Corrective action Notes
OBJECT error DBETE Table space, table space partition, index space, index partition, or logical index partition
Issue -DISPLAY command to see the status of the object. If the object is in DBETE along with restrictive states such as RECP, RBDP, PSRBD, use one of the following utilities to recover or rebuild the object:
  • RECOVER utility
  • LOAD utility with the REPLACE option
  • REBUILD utility

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

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.

DBETE, RECP, RBDP, and PSRBD status can also be reset by issuing the following command, -START DB(db name) SP(space name) ACCESS(FORCE).

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

  
End of change