IT36344: SQL ALTERNATE INSTANCE RESTORE FAILS WITH "OBJECT NOT FOUND IN INVENTORY"

APAR status

• Closed as program error.

Error description

• An SQL alternate instance restore will fail if the original
  instance is no longer in the inventory catalog.
  
  The Job Log
  for the restore will contain the following messages:
  CTGGA0895
  Object was not found in inventory.
  CTGGA1109 Failed to load
  source item (<database_name>).
  
   Initial impact:
  Medium
  Versions affected: 10.1.4-10.1.7
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.x.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the fixing level when available. This problem is       *
  * projected to be fixed in IBM Spectrum Protect Plus level     *
  * 10.1.8. Note that this is subject to change at the           *
  * discretion of IBM.                                           *
  ****************************************************************
  

Problem conclusion

• Database restore job to an alternate instance will complete
  successfully even if the original source server is removed from
  IBM Spectrum Protect Plus.
  

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