IT21045: DSMAGENT CRASHES WHEN PERFORMING VSS BACKUP AGAINST A HIGH NUMBER OF MICROSOFT SQL DATABASE

IBM Spectrum Protectâ„¢ Client 7.1.8 Downloads and READMEs
IBM Spectrum Protectâ„¢ Client 8.1.4 Downloads and READMEs

APAR status

• Closed as program error.

Error description

• The dsmagent.exe process may crash when performing a high number
  (more than 254) of Microsoft SQL backups (vss method) via IBM
  Spectrum Protect for Databases ? Data Protection for Microsoft
  SQL Server.
  
  The following errors are reported in dsmerror.log:
  
  ANS5250E An unexpected error was encountered.
     TSM function name : vssCreateLocalBackup
     TSM function      : No memory to allocate snapVolEntry_t
  structure
     TSM return code   : 102
     TSM file          : ..\..\common\winnt\vssback.cpp (6609)
   ANS5250E An unexpected error was encountered.
     TSM function name : baCreateLocalBackup
     TSM function      : VSS Create Local Backup Failed
     TSM return code   : 102
     TSM file          : ..\..\common\ba\backsnap.cpp (2452)
  
  Nothing is reported in tdpsql.log
  
  
  
  Customer/L2 Diagnostics:
  The dump analysis of the dsmagent shows:
  STACK_TEXT:
  dsmagent!llGetItemAt+0x50
  dsmagent!VssRequestor::getRequest+0xf0
  dsmagent!VssRequestor::abortCSVBackup+0x113
  dsmagent!VssRequestor::VssBackupComplete+0x138
  dsmagent!VssRequestor::abortBackup+0x4d
  dsmagent!vssAbortBackup+0x253
  dsmagent!tlPostProcessTxnSpec+0x912
  dsmagent!DccTxnConsumer::HandleRcPrivFlush+0x494
  dsmagent!DccTxnConsumer::HandleQueue+0x71c
  dsmagent!DccTxnConsumer::Run+0x6a2
  dsmagent!DccTxnConsumer::DoThread+0xc4
  
  The issue does not occur if performing a legacy backup
  
  IBM Spectrum Protect Versions Affected: IBM Spectrum Protect
  backup-archive client v7.1 and v8.1 on Windows platforms
  
  Initial Impact: medium
  
  Additional Keywords: ANS5250E dsmagent baCreateLocalBackup
  vssCreateLocalBackup vss crash sql backup tdpsqlc tsm IBM
  Spectrum
  

Local fix

• Backup the Microsoft SQL DB  with IBM Spectrum Protect for
  Databases ? Data Protection for Microsoft SQL Server in groups
  of 254 DBs (or less) or use the legacy method backup
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Backup-archive client versions 7.1 and 8.1 running on all    *
  * Microsoft Windows platforms.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * This issue is projected to be fixed in the Backup-Archive    *
  * Client version 7.1.8 and 8.1.4 on all Microsoft Windows      *
  * platforms                                                    *
  * Note that this is subject to change at the discretion of     *
  * IBM.                                                         *
  ****************************************************************
  

Problem conclusion

• The problem when attempt to back up more then 255 MS SQL
  databases did lead to the crash and the hang has been fixed so
  that it no longer occurs.
  

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

• dsmc
  

Fix information

• Fixed component name

  TSM CLIENT

• Fixed component ID

  5698ISMCL

Applicable component levels

• R71W PSY

     UP

• R81W PSY

     UP