IT26984: AFTER A FAILED DB2 RESTORE THE DB2 LOG DIRECTORY DOES NOT GET CLEANED UP AND A SUBSEQUENT RESTORE CAN FAIL

APAR status

• Closed as program error.

Error description

• A rerun of an IBM Spectrum Protect Plus Db2 Application restore
  operation of a Db2 database might fail because the previously
  failed restore operation did not clean up all directories that
  were created during this previous restore operation.
  
  In the Joblog of the restore operation the following error can
  be found:
  'Cancelling restore. One or more target directories are not
  empty. The following directories, symbolic links or files have
  existing data: /db2_log/log/NODE0000'
  
  The same error can occur for other directories as well if they
  were not cleaned up correctly.
  
  
  Products & versions affected:
  IBM Spectrum Protect Plus Version 10.1.2 using Db2 Application
  Agent
  
  Platforms affected:
  AIX, Linux
  

Local fix

• After a failed Db2 restore one of the following can be used:
  - Manually clean up the Db2 log directory or any other directory
  or symbolic link mentioned in the error message on the Db2
  application server and rerun the Db2 restore operation with the
  same options used for the previously failed restore.
  - Rerun the Db2 restore operation with the 'Overwrite existing
  databases' option selected.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.2 protecting Db2        *
  * databases                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * see ERROR description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed IBM Spectrum Protect Plus level        *
  * 10.1.3. Note that this is subject to change at the           *
  * discretion of IBM                                            *
  ****************************************************************
  

Problem conclusion

• The issue has been corrected so that leftovers resulting from a
  failed restore operation are cleaned from disk tidily.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels