DSNI046I csect-name OBJECT IN ERROR REASON reason-code ERQUAL error-qualifier NAME object-name DBID database-id OBID object-id LRSN log-record>

Explanation

An error occurred during processing of a table space, table space partition, index space, index partition, or logical index partition. One of the following conditions occurred:

  • An error occurred when Db2 processed a DBET exception state for a table space, index space, or partition of a partitioned object.
  • An error occurred when Db2 was unable to access a page set in backward log recovery phase during restart.
csect-name
The name of the control section that issued the message.
reason-code
The Db2 reason code that is listed in the dump that accompanies this message.
error-qualifier
The abend in the control section that caused this message to be issued.
object-name
The name of the table space or index space that encountered the problem. A partition number is included where applicable.
database-id
The database identifier (DBID).
object-id
The object identifier (OBID).
log-record
The LRSN or RBA of the log record that was being processed when the error occurred. If no log record was being processed, this value is blank.

System action

The system action depends on the situation in which the error occurred:

Accessing a page in backward log recovery phase
Db2 places the table space or index space in RECP and DBETE status. It then abends and generates a dump. Db2 tolerates the page set access error so that it can restart.
Processing a DBET exception state
Db2 places the table space or index space in RECP, RBDP, or PSRBD status and DBETE status. It then abends and generates a dump. Db2 tolerates the exception state error so that it can restart or the RESTORE SYSTEM utility can continue.

User response

Issue the appropriate DISPLAY command to see the status of the object. Use one of the following methods to reset the DBETE and RECP, RBDP, or PSRBD statuses:

  • Use the RECOVER utility or the LOAD utility with the REPLACE option to recover a table space or index space.
  • Use the REBUILD INDEX utility to rebuild an index space.
  • Use the START DATABASE command with the following options:
    START DATABASE(database-name) 
   SP(space-name) ACCESS(FORCE)

Contact IBM® Software Support to report the problem. Db2 log records need to be analyzed in order to diagnose the cause of the problem, and determine if the exception state error needs to be handled.