DSNU510I NO RECOVERY BASE AVAILABLE FOR RECOVERY OF obj-type obj-qual.obj-name

Explanation

It is not possible to locate a good recovery base. A recovery base could be either a full image copy or a system-level backup. If you only take image copies, the following conditions are possible:
  • No back level image copy exists, or
  • An I/O error occurred while reading the back level image copies, or
  • Db2 was unable to locate a suitable image copy
The return code that accompanies this message is 0 (informational) or 8 (error) under the following conditions:
0 (informational)
A full image copy is not found in the SYSCOPY table during RECOVER initialization or during fall back processing or if YES was specified for the value of the SYSTEM_LEVEL_BACKUPS subsystem parameter and a system-level backup was not chosen by RECOVER as a recovery base. However, a LOG(YES) event was detected and recovery continues from the log. Note that if you have performed a REORG after your last image copy or system-level backup, then the image copy of system-level backup will not be chosen as the recovery base.
8 (error)
The RECOVER utility is in fallback mode and no base recoverable point (a full image copy or LOG(YES) event) was found in the SYSCOPY table. Further utility processing is terminated.

System action

If the return code is 0, processing continues. If the return code is 8, further utility processing is terminated.

System programmer response

If the return code is 8 and the object being recovered is a table space, the data must be repaired so that a backup can be taken.

User response

Notify the system programmer if the return code is 8. If the return code is 0, no action is required.

Severity

0 (informational) or 8 (error)