DSNU511I csect-name RECOVERY INFORMATION INDICATES THAT obj-type obj-qual.obj-name IS NOT IN A RECOVERABLE STATE

Explanation

The requested recovery of an object would result in recovery entirely from the log. Because the object is also in copy pending status, recovery might fail in log apply in these situations:
  • A previous MODIFY utility job deleted the last recoverable point indicated in the SYSCOPY catalog table.
  • A previous MODIFY utility job deleted all SYSCOPY entries.
In either case, the MODIFY utility leaves the object in copy pending status and the RECOVER utility is unable to determine the reliability of recovery from the log.

System action

The RECOVER utility terminates with return code 8.

User response

Determine the recoverability status of the object. SYSCOPY information is probably not useful as no recoverable point (FULL IMAGE COPY, REORG LOG(YES) or LOAD REPLACE LOG(YES)) was found by the RECOVER utility. User information might be the only indication about recoverability.

To allow RECOVER to execute, copy pending status must be turned off. It is safest to make a full image copy before attempting the recovery. Then run the RECOVER utility with the TORBA or TOLOGPOINT option.

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.

Problem determination

Collect the following diagnostic items:
  • Console output from the system on which the job was run, and a listing of the SYSLOG data set for the period of time that spans the failure.
  • Dynamic dump, taken to SYS1.DUMPxx data set, by Db2 (04E and 04F abends).
  • Listing of SYS1.LOGREC data set, obtained by executing IFCEREP1.

Severity

8 (error)