IBM Support

IT28454: ORIGINAL DATABASE GETS UNUSABLE BY A REDIRECTED TEST RESTORE TO ORIGINAL HOST

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • During test restore of a Db2 database to an alternate instance
    on the same host the following error message is received:
    
    [2019-03-10T11:10:53.996Z] ERROR asyncTaskExecutor-124
    com.catalogic.ecx.remoteexecutor.impl.RemoteExecutorUtils
    1551373684143 A backup of the database DBA1 cannot be restored
    to a different instance db2inst2 on the same host.
    Select an alternate instance in a different host and retry the
    operation.
    
    Upon failing, a clean up is run and removes both the new
    database that was attempted to restore, along with the
    production (original) database.
    [2019-03-10T11:10:55.034Z] ERROR asyncTaskExecutor-124
    c.c.e.s.recovery.application.steps.DatabaseRestoreBaseStep
    1551373684143 Failed to restore databases (DBA1) on server
    (192.168.3.77) (Completed).
    [2019-03-10T11:10:55.037Z] ERROR asyncTaskExecutor-124
    c.c.e.s.recovery.application.steps.DatabaseRestoreBaseStep
    1551373684143 Failed to restore databases (DBA1). ... ...
    [2019-03-10T11:11:28.744Z] INFO Thread-2941
    com.catalogic.ecx.remoteexecutor.impl.RemoteExecutorUtils
    1551373684143 --- Running restorecleanup for db2 agent ---
    [2019-03-10T11:11:28.750Z] INFO Thread-2941
    com.catalogic.ecx.remoteexecutor.impl.RemoteExecutorUtils
    1551373684143 Db2 agent 10.1.3.1546824564 started.
    [2019-03-10T11:11:28.757Z] INFO Thread-2941
    com.catalogic.ecx.remoteexecutor.impl.RemoteExecutorUtils
    1551373684143 Removed Db2 database DBA1 on instance host1 /
    db2inst1
    [2019-03-10T11:11:28.765Z] INFO Thread-2941
    com.catalogic.ecx.remoteexecutor.impl.RemoteExecutorUtils
    1551373684143 Removed Db2 database DBA2 on instance host1 /
    db2inst2
    [2019-03-10T11:11:28.771Z] INFO Thread-2941
    com.catalogic.ecx.remoteexecutor.impl.RemoteExecutorUtils
    1551373684143 Removed symbolic link for directory /db2inst1/
    [2019-03-10T11:11:28.778Z] INFO Thread-2941
    com.catalogic.ecx.remoteexecutor.impl.RemoteExecutorUtils
    1551373684143 Removed symbolic link for directory /db2inst2/
    
    The fact that the redirected restore is failing with said
    message is expected by design.
    The actual issue is the consequence that the original database
    becomes unusable.
    
    Affected product: IBM Spectrum Protect Plus db2 agent v10.1.3
    
    Platforms affected: All AIX, All LNX
    Initial Impact: --> 1
    Additional Keywords: SPP, db2_agent
    
    See also:
    See also
    https://www.ibm.com/support/docview.wss?uid=ibm10843068#Db2%20sp
    ecific, "Restoring IBM Spectrum Protect Plus Db2 data to an
    alternative instance on the original host"
    

Local fix

  • For a redirected restore, do not select any instance located on
    the original host.
    

Problem summary

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

Problem conclusion

  • The issue has been corrected so that the cleanup of a failed
    restore does not cleanup the original (production) database.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT28454

  • Reported component name

    SP PLUS

  • Reported component ID

    5737SPLUS

  • Reported release

    A13

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-03-14

  • Closed date

    2019-04-16

  • Last modified date

    2019-04-16

  • 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A13","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
30 January 2024