IT06881: DELETE VOLHISTORY TYPE=BACKUPSET MAY CRASH THE SERVER

7.1.3.000-TIV-TSMSRV-WIN
7.1.3.000-TIV-TSMSRV-SolarisSPARC
7.1.3.000-TIV-TSMSRV-Linuxx86_64
7.1.3.000-TIV-TSMSRV-Linuxs390x
7.1.3.000-TIV-TSMSRV-Linuxppc64
7.1.3.000-TIV-TSMSRV-HP-UX
7.1.3.000-TIV-TSMSRV-AIX

APAR status

• Closed as program error.

Error description

• The Tivoli Storage Manager server may crash when the DELETE
  VOLHIST command with the undocumented TYPE=BACKUPSET option,
  introduced by APAR IC64771, is issued.
  The crash occurs when two or more volumes belong to the same
  operation but one of them is an orphan volume
  where the COMMAND row in the table SEQ_VOLUME_HISTORY isn't
  filled as expected.
  
  The undocumented option was build for a specific error case only
  and shouldn't be used instead of the DELETE BACKUPSET
  command.
  
  
  Customer/L2 Diagnostics:
  The callstack of the crash (here on Linux) might look as
  follows:
  #0  0x00007f8443494f17 in memcpy () from /lib64/libc.so.6
  #1  0x0000000000aa0e59 in GetObjectSetInfo (command=<optimized
  out>, cmdLenP=<optimized out>, objIdP=<optimized out>,
  genDateP=<optimized out>, volName=<optimized out>, maxDate=...,
  txnId=0x2292198) at icvolhst.c:7427
  #2  icDelOrphanObjectSetVol (cmdP=0x42f3828, maxDate=...,
  volName=<optimized out>, force=<optimized out>,
  devClass=0x7f841dbefc60 "", deletedP=0x7f841dbefc8c) at
  icvolhst.c:4699
  #3  0x00000000ffffffff in ?? ()
  #4  0x00007f8426260f04 in ?? ()
  #5  0x00007f8426260e50 in ?? ()
  #6  0x0000000000000000 in ?? ()
  
  You can use the following SQL command to check if the COMMAND
  row for the affected volume
  in the SEQ_VOLUME_HISTORY table is empty:
  
  db2 "SELECT * from TSMDB1.SEQ_VOLUME_HISTORY where
  volname='TEST123'"
  
  DATETIME   VOLTYPE [...] OPERATION [...] VOLNAME COMMAND
  1414285014      10       289926083       TEST123 -
  
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager server: All supported versions on all
  platforms
  
  Initial Impact:
  Low
  
  Additional Keywords:
  TSM, dump, delete volhist, backupset, SEQ_VOLUME_HISTORY,
  IC64771
  

Local fix

• Identify the other volumes belonging to the backupset and update
   the corresponding table entry using:
  db2 connect to tsmdb1
  db2 set schema tsmdb1
  db2 "update tsmdb1.seq_volume_history set command='<command used
  to create backupset>' where datetime=<datetime seen in
  SEQ_VOLUME_HISTORY> and
  VOLNAME='<affected volume>'"
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Tivoli Storage Manager server users.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in level 7.1.3. Note that this is      *
  * subject to change at the discretion of IBM.                  *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms:  AIX, HP-UX, Solaris, Linux, and Windows.
  

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

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels

• R71A PSY

     UP

• R71H PSY

     UP

• R71L PSY

     UP

• R71S PSY

     UP

• R71W PSY

     UP