IT24051: SERVER ON WINDOWS CAN CRASH RUNNING A SELECT FROM CONTAINERS IF BACKSLASHES ARE MISSING IN THE CONTAINER FILE NAME

7.1.9.000-TIV-TSMCMS-Windows64
7.1.9.000-TIV-TSMCMS-Windows32
7.1.9.000-TIV-TSMCMS-Linuxx64
7.1.9.000-TIV-TSMOC-LinuxS390
7.1.9.000-TIV-TSMOC-LinuxPPC64
7.1.9.000-TIV-TSMOC-Windows
7.1.9.000-TIV-TSMOC-Linuxx64
7.1.9.000-TIV-TSMOC-AIX
7.1.9.000-TIV-TSMSRV-WIN
7.1.9.000-TIV-TSMSRV-SolarisSPARC
7.1.9.000-TIV-TSMSRV-Linuxx86_64
7.1.9.000-TIV-TSMSRV-Linuxs390x
7.1.9.000-TIV-TSMSRV-Linuxppc64
7.1.9.000-TIV-TSMSRV-HP-UX
7.1.9.000-TIV-TSMSRV-AIX
8.1.5.000-IBM-SPCMS-WindowsX64
8.1.5.000-IBM-SPCMS-WindowsI32
8.1.5.000-IBM-SPCMS-Linuxx86_64
8.1.5.000-IBM-SPOC-WindowsX64
8.1.5.000-IBM-SPOC-Linuxx86_64
8.1.5.000-IBM-SPOC-Linuxs390x
8.1.5.000-IBM-SPOC-LinuxPPC64le
8.1.5.000-IBM-SPOC-AIX
8.1.5.000-IBM-SPSRV-WindowsX64
8.1.5.000-IBM-SPSRV-Linuxx86_64
8.1.5.000-IBM-SPSRV-Linuxs390x
8.1.5.000-IBM-SPSRV-Linuxppc64le
8.1.5.000-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1 Fix Pack 5 (V8.1.5) Downloads
IBM Spectrum Protect Server V7.1 Fix Pack 9 (7.1.9.000) Downloads

APAR status

• Closed as program error.

Error description

• Any select from the containers table from dsmadmc command line,
  can crash the server when running on Windows platform, if
  backslashes are missing in the container file name.
  
  From analysing the crash from a Windows server it can be seen:
  
  adsmdll!sdQueryContainer+0xc43
  adsmdll!AdmUseExtCmdTab+0x175a
  adsmdll!AdmCommandLocal+0x520
  adsmdll!admCommand+0x12c6
  adsmdll!PreFlushDataForSQL+0x4bb
  adsmdll!ScrubCmdInput+0xaaa
  adsmdll!PreProcessQuery+0x282
  adsmdll!AdmSQLExecute+0x9d
  adsmdll!AdmCommandLocal+0x520
  adsmdll!admCommand+0x12c6
  adsmdll!SmAdminCommandThread+0x2a
  adsmdll!startThread+0x141
  msvcr120!_callthreadstartex+0x17
  msvcr120!_threadstartex+0x102
  kernel32!BaseThreadInitThunk+0x22
  ntdll!RtlUserThreadStart+0x34
  
  No error is seen in the activity log. The last entry logged will
  be the failing select from containers table.
  
  
  
  Initial Impact: Medium
  
  
  
  Tivoli Storage Manager and IBM Spectrum Protect versions
  affected: Server  7.1.x and 8.1.x  on Windows
  
  
  
  Additional Keywords:  TSM Spectrum Protect error select path
  slashes forward backward missing
  

Local fix

• The following DB2 select can be used instead:
  DB2 "select * from containers"
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Spectrum Protect server users.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in levels 7.1.9 and 8.1.5. Note that   *
  * this is subject to change at the discretion of IBM.          *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms for reported release:  Windows.
  Platforms fixed:  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

• R71W PSY

     UP

• R81W PSY

     UP