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

IBM Tivoli Storage Manager (TSM) server V6.3.3.x interim fix downloads

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