Start of change

DSNU527I csect-name DB2 OBJECT RECOVERED TO AN INDETERMINATE POINT

Explanation

The image copy data set specified with the TOCOPY keyword of the RECOVER utility was one of the following:
  • An image copy data set made with the SHRLEVEL CHANGE option. In this mode, changes might have been made to the object while the image copy was in progress. If a change was made to a page before the image copy processed the page, the update is in the copy data set. If a change was made to a page after the image copy processed it, the change is not in the copy data set. The data set might contain partial updates from some transactions.
  • An image copy data set made during a LOAD REPLACE operation. When the ENFORCE or INDEXVAL phases are not executed, an image copy produced during LOAD REPLACE will not contain updates made to the table space to correct unique index violations during the INDEXVAL phase or referential constraint violations during the ENFORCE phase. Therefore, it is not recommended as a recovery point.

If the object recovered is a table space, indexes on the table space are placed in REBUILD-pending status and dependent table spaces, if any, are placed in CHECK-pending status. Message DSNU831I indicates that indexes are placed in REBUILD-pending status, and message DSNU563I indicates that dependent table spaces are placed in CHECK-pending status.

System action

The utility terminates normally.

User response

Based on the explanation above, determine if the recovery is satisfactory. Rebuild the indexes that are identified by message DSNU830I in the job output. Run the CHECK DATA utility on the table spaces that are identified by message DSNU563I to correct any referential constraint violations.

If you suspect an error in Db2, you might need to report the problem. For information about identifying and reporting the problem, see Collecting diagnostic data.

Severity

4 (warning)

End of change