DSNB328I OBJECT NAME object-name OBJECT ID X'object-id' REMAINS IN status-type STATUS. USER ACTION IS NEEDED TO RECOVER THE OBJECT

Explanation

Db2 left an object in GRECP status.

object-name

The identifier of the object that was left in the indicated status. It uses one of the following formats:

• db-name.space-name for table spaces and index spaces.
• db-name.space-name.part-number if the object is a partition within a table space or index space

Rarely object-name might contain asterisks and internal identifiers, such as ****0010.****0002, if Db2 cannot obtain the object name.

object-id

The internal DBID and PSID identifiers, for use by IBM® Support.

status-type

Indicates the type of status being reported by the message:

GRECP

Objects were found in group buffer pool recovery pending status.

LPL

objects were found with pages in the logical page list.

Reasons that the object remains in the specified status include the following examples:

• Db2 attempted several times but failed to automatically recover the objects, and this member stopped trying automatic recovery
• Db2 does not recovery objects in GRECP status in certain conditions, such as the following examples:
  • ACCESS(MAINT) is specified when Db2 is started.
  • LIGHT is specified when Db2 is started.
  • The objects in GRECP status use a buffer pool that has the AUTOREC=NO attribute.
  • The objects in GRECP status are deferred by the value of the RESTART or DEFER field on panel DSNTIPS.