IT17252: RESTORE FROM VMVSS BACKUP TERMINATES WITH ANS9892E IF THE DATABASE IS LOCATED BEHIND A MOUNTPOINT

IBM Spectrum Protect client 7.1.6.x interim fix downloads

APAR status

• Closed as program error.

Error description

• Tivoli Storage Manager for Virtual Environments - Data
  Protection for VMware provides a database level recovery
  from virtual guest backups using Tivoli Storage Manager for
  Databases - Data Protection for Microsoft SQL Server and
  Tivoli Storage Manager for Mail - Data Protection for Microsoft
  Exchange Server.
  If database files are located behind a mountpoint, restore of
  such database may terminate with with the following error
  sequences in the guest agent node logs:
  tdpsql.log:
  ANS9892E (RC974)  Unable to find snapshot(s) in the local
  repository.
  ACO5060E A Tivoli Storage Manager API error has occurred.
  dsmerror.log:
  ANS5250E An unexpected error was encountered.
     TSM function name : objEnumGetNextObj
     TSM function      : Unable to find volume '<volume mount
  point>' for file '<database file behind the mount point>' in
  snap volume list
     TSM return code   : 105
  
  Products affected:
  IBM Spectrum Protect Backup-Archive Client version
  7.1 on Linux and Windows
  Note: The Backup-Archive Client is a prerequisite to using the
  Data Protection for VMware. In Data Protection for VMware
  environments, the Backup-Archive Client is also known as the
  data mover.
  
  This problem also affects IBM Spectrum Protect for Virtual
  Environments: Data Protection for VMware 8.1.0. If you are using
  Data Protection for VMware 8.1.0, refer to APAR IT19216.
  
  Initial Impact: High
  Additional Keywords: tsm spectrum protect sql exchange restore
  file-level vmtsmvss application protection
  

Local fix

• Mount the snapshots using Recovery agent and restore database
  files from the mounted snapshot manually.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of:                                                    *
  * Spectrum Protect for Mail: Data Protection Microsoft         *
  * Exchange Server 7.1                                          *
  *  Spectrum Protect Snapshot for Microsoft Exchange Server 4.1 *
  *  Spectrum Protect for Databases: Data Protection for         *
  * Microsoft SQL Server 7.1                                     *
  *  Spectrum Protect Snapshot for Microsoft SQL Server 4.1      *
  *                                                              *
  * who perform restore from VMVSS backups.  Which was done by   *
  * IBM Spectrum Protect for Virtual Environments Data           *
  * Protection for VMware Data Mover version 7.1  on Windows x64 *
  * platform                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * This issue is projected to be fixed in the Backup-Archive    *
  * Client version 7.1.6.5 and 7.1.8 on all Microsoft Windows    *
  * x64 platforms                                                *
  * Note 1: The Backup-Archive Client is a prerequisite to using *
  * the Data Protection for VMware. In Data Protection for       *
  * VMware environments, the Backup-Archive Client is also known *
  * as the data mover.                                           *
  * Note 2: This is subject to change at the discretion of IBM.  *
  ****************************************************************
  

Problem conclusion

• Spectrum Protect backup-archive client has been updated to
  handle correctly a restore of Microsoft Exchange and SQL
  databases that are located behind a mount point from VMVSS
  backups.
  

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:

  IT19216

Modules/Macros

• dsmagent
  

Fix information

• Fixed component name

  TSM CLIENT

• Fixed component ID

  5698ISMCL

Applicable component levels

• R71W PSY

     UP