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
- 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)