IC94586: FAILURES TO TRUNCATE SQL LOGS WITH APPLICATION PROTECTION ARE NOT REPORTED

IBM Tivoli Storage Manager (TSM) Client 7.1.1 Downloads and READMEs

APAR status

• Closed as program error.

Error description

• When using the Self-contained Application Protection feature of
  Tivoli Storage Manager for Virtual Environments with a Microsoft
  SQL Server, the batch function which truncates the transaction
  logs may not report failures correctly.  The backup itself will
  work without error, but there  will be no entries in the
  Microsoft Application event logs.
  The supplied batch file, TsmMSSqlLogTruncation.bat is not
  reporting the failure correctly and returning a RC-0.
  
  Tivoli Storage Manager Versions Affected:
    Tivoli Storage Manager for Virtual Environments 6.4
  
  Customer/L2 Diagnostics:
  A trace of the backup will show the following output when the
  batch file is called:
  ----------------------------------------------------------------
  [005108] [5068] : ..\..\common\vm\acm.cpp(1324):
  ACM::TruncateSqlLogs(): Contents of guest trace:
  [005108] [5068] : ..\..\common\vm\acm.cpp( 739):
  ACM::PrintFileToTrace(): ENTER
  [005108] [5068] : ..\..\common\vm\acm.cpp( 751): Tracing started
  for TsmMSSqlLogTruncation.bat
  [005108] [5068] : ..\..\common\vm\acm.cpp( 751): Tracing ended
  for TsmMSSqlLogTruncation.bat
  [005108] [5068] : ..\..\common\vm\acm.cpp( 762):
  ACM::PrintFileToTrace(): EXIT, rc = 0
  [005108] [5068] : ..\..\common\vm\acm.cpp(1330):
  ACM::TruncateSqlLogs(): EXIT, rc = 0
  [005108] [5068] : ..\..\common\vm\acm.cpp( 900):
  ACM::Complete(): EXIT, rc = 0
  ----------------------------------------------------------------
  
  However a successful run will show the following:
  ----------------------------------------------------------------
  [003792] [3160] : ..\..\common\vm\acm.cpp( 751): Tracing started
  for TsmMSSqlLogTruncation.bat
  [003792] [3160] : ..\..\common\vm\acm.cpp( 751):
  ===========================================
  [003792] [3160] : ..\..\common\vm\acm.cpp( 751): SERVER:
  SQLSRV2012
  [003792] [3160] : ..\..\common\vm\acm.cpp( 751):
  ===========================================
  [003792] [3160] : ..\..\common\vm\acm.cpp( 751):
  -------------------------------------------
  [003792] [3160] : ..\..\common\vm\acm.cpp( 751): Database: model
  [003792] [3160] : ..\..\common\vm\acm.cpp( 751):
  -------------------------------------------
  [003792] [3160] : ..\..\common\vm\acm.cpp( 751): 100 percent
  processed.
  [003792] [3160] : ..\..\common\vm\acm.cpp( 751): Processed 5
  pages for database 'model', file 'modellog' on file 1.
  [003792] [3160] : ..\..\common\vm\acm.cpp( 751): BACKUP LOG
  successfully processed 5 pages in 0.003 seconds (13.020 MB/sec).
  ----------------------------------------------------------------
  
  Initial Impact: Medium
  
  Additional Keywords:tdpve tsm4ve tsmforve
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Backup-archive client version 6.4 running    *
  *                 on all Microsoft Windows and Linux           *
  *                 platforms.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: See ERROR DESCRIPTION                   *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be fixed   *
  *                 in level 6.4.2. Note that until the fixing   *
  *                 level is available, this information is      *
  *                 subject to change at the discretion of IBM.  *
  ****************************************************************
  *
  

Problem conclusion

• The backup-archive client now reports if an error occured with
  sqlcmd command.
  

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

• DSM
  

Fix information

• Fixed component name

  TSM CLIENT

• Fixed component ID

  5698ISMCL

Applicable component levels

• R64L PSY

     UP

• R64W PSY

     UP