IC87653: RESTORE OF DATA PROTECTION FOR SQL LEGACY BACKUP CAN FAIL WITH ACO5456W FROM REPLICATED SERVER

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Using Tivoli Storage Manager  for Databases: Data Protection for
    Microsoft SQL, a backup is sent to a Tivoli Storage Manager
    6.3.1.0 server. The node, used by Data Protection for Microsoft
    SQL, is then replicated to a target Tivoli Storage Manager
    server. Subsequent restore of the  Data Protection for Microsoft
    SQL is successful from the source Tivoli Storage Manager server
    but attempts to restore from the replicated Tivoli Storage
    Manager server fail with the following errors:
    .
    07/04/2012 17:10:21 ACO5456W The backup is corrupt and is not
    fully restorable.
    07/04/2012 17:10:21 Processing will continue.
    07/04/2012 17:10:28 ACO5436E A failure occurred on stripe number
    (0),  rc = 428
    07/04/2012 17:10:28 ACO5407E The SQL server aborted the
    operation.
    07/04/2012 17:10:28 Restore of tsmxxx failed.
    07/04/2012 17:10:28 An exception occurred while executing a
    Transact-SQL statement or batch.
    07/04/2012 17:10:28 The volume on device 'TDPSQL-00000340-0000'
    is empty.
    
    
    Customer/L2 Diagnostics (if applicable)
    On the source server:
    1. The client backs up with a temp name
    2. Once the backup completes the client renames to the final
    name of "'full'
    3. The Node is replicated to the target server
    
    On the target server:
    1. The replicated references the backup by its original, temp
    name
    
    After replication, we have a name reference of "full" on the
    source server and the original, temp name on the target server.
    When restoring the client, the process will be looking for the
    object named like "full" which does not existing on the target
    server.   Therefore the restore fails.
    
    A client side SERVICE trace will show the query, insert, and
    then the rename of the object:
    12:43:05.188 [34][smtrans.c][1915][SmRecvVerbX]: Contents of
    verb (0x3f00) BackQryEnhanced3, length=96, extended=1:
    ...
    12:43:05.305 [34][smtrans.c][1915][SmRecvVerbX]: Contents of
    verb (0xc5) BackInsNormEnhanced, length=354, extended=0:
    ...
    12:43:05.311 [34][smtrans.c][1661][SmRecvVerbX]: Contents of
    verb (0x97) BackRenameEnhanced, length=90, extended=0:  <---
    Here
    
    *NOTE*
    The rename is part of the Data Protection client processing.
    
    Platforms affected:
    Unix/Linux/Windows 6.3
    
    Initial Impact: Medium
    
    Additional Keywords: repl client res Data Protection TivoliZZ63
    

Local fix

  • Restore from the source server if the object is still available
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Tivoli Storage Manager server users.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
    ****************************************************************
    * RECOMMENDATION: Apply fixing level when available. This      *
    *                 problem is currently projected to be fixed   *
    *                 in level 6.3.4. Note that this is subject    *
    *                 to change at the discretion of IBM.          *
    ****************************************************************
    *
    

Problem conclusion

  • This problem was fixed.
    Affected platforms:  AIX, HP-UX, Solaris, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC87653

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    63L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-30

  • Closed date

    2012-12-07

  • Last modified date

    2012-12-07

  • 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

    TSM SERVER

  • Fixed component ID

    5698ISMSV

Applicable component levels

  • R63A PSY

       UP

  • R63H PSY

       UP

  • R63L PSY

       UP

  • R63S PSY

       UP

  • R63W PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager

Software version:

63L

Reference #:

IC87653

Modified date:

2012-12-07

Translate my page

Machine Translation

Content navigation