IT37582: SQL RESTORE FAILS IF LESS STRIPES ARE USED FOR RESTORE THAN FOR BACKUP

APAR status

• Closed as program error.

Error description

• An IBM Spectrum Protect for Databases - Data Protection for SQL
  backup is performed using X stripes.
  That backup completes successfully.
  If then a restore is performed using Y stripes and Y is less
  than X, it will stop with messages similar to:
     [date]  [time] Restore of <DATABASE> failed.
     [date]  [time] An exception occurred while executing a
      Transact-SQL statement or batch.
     [date]  [time] The backup or restore was aborted.
     [date]  [time] Read on "TDPSQL-00001A44-0000" failed: 995
      (The I/O operation has been aborted because of either a
      thread exit or an application request.)
     [date]  [time] RESTORE DATABASE is terminating abnormally.
     [date]  [time] Cannot continue the execution because the
      session is in the kill state.
     [date]  [time] A severe error occurred on the current
     command.  The results, if any, should be discarded.
  
  An IBM Spectrum Protect for Databases - Data Protection for SQL
  trace using the Microsoft Management Console will show in file
  "fcm_TraceFileSql.trc"
    [date] [time] [006724] [7932] : restorst.cpp        (1016):
    Consumer thread already exit. Exit the loop[date] [time]
    [006724] [7932] : restorst.cpp        (1098): Exit
    CRestoreStripe::RUN(), rc = 0, msg = (null)
  
  IBM Spectrum Protect Versions Affected: IBM Spectrum Protect for
  Databases - Data Protection for SQL 8.1.9.1 or later on all
  supported platforms
  | MDVREGR 8.1.9.1-TIV_5698DPSAP |
  
  Additional Keywords: TS005537722 stripes restore SQL fail
  

Local fix

• Use the same number of stripes during restore as used during
  backup by setting "stripes X" in Data Protection for SQL Server
  preferences file (tdpsql.cfg).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect for Databases: Data Protection for      *
  * Microsoft SQL Server versions 8.1.9.1, 8.1.9.2, 8.1.12 and   *
  * 8.1.13.                                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * This issue is projected to be fixed in the Data Protection   *
  * for Microsoft SQL Databases version 8.1.14 on Microsoft      *
  * Windows x64 platform.                                        *
  * Note: This is subject to change at the discretion of IBM.    *
  *                                                              *
  ****************************************************************
  

Problem conclusion

• The restore operation should be successful even if less number
  of stripes are used during restore than used during the backup
  operation.
  

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

  TDP FOR SQL WIN

• Fixed component ID

  5698DPSAP

Applicable component levels