IT04442: SQL BACKUPS MAY FAIL IF THE PRIMARY STORAGE POOL IS ASSOCIATED TO A NON-WRITABLE COPY STORAGE POOL

APAR status

• Closed as Permanent restriction.

Error description

• When using either:
  - Tivoli Storage Manager for Databases: Data Protection for
    Microsoft SQL Server 7.1
  - Tivoli Storage FlashCopy Manager: FlashCopy Manager for
    Microsoft SQL Server 4.1
  SQL backups may fail if the primary storage pool is associated
  to a non-writable copy storage pool. For example: If the copy
  storage pool is set to "read-only", does not have enough scratch
  volumes allocated, or the "Auto-copy" mode is set to "Client".
  The expected result is that the backup would continue and be
  automatically redirected to the primary storage pool instead.
  

Local fix

• Resolve the storage pool configuration issue on the TSM Server
  and re-run the backup when such an error is detected.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of:                                    *
  *                 Tivoli Storage FlashCopy Manager for         *
  *                 Microsoft SQL Server  3.1,3.2, and           *
  *                 4.1Tivoli Storage Manager for                *
  *                 Databases: Data Protection for Microsoft     *
  *                 SQL Server 6.3, 6.4, and 7.1                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: See ERROR DESCRIPTION                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This is a permanent restriction of the product.
  

Problem conclusion

• Open a new work item for that
  

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:

Modules/Macros

• DPSQL
  

Fix information

Applicable component levels