IC68102: TIVOLI STORAGE MANAGER SERVER MAY CRASH WHILE PARSING INVALID SQL SELECT SYNTAX

APAR status

• Closed as program error.

Error description

• The Tivoli Storage Manager Server may crash while attempting to
  parse through an invalid sql select statement when double quote
  was used when single quote should be.
  
  For example,
  
  The following command can cause tivoli storage manager to crash:
  
  select volume_name from contents where
  file_name="/vol/namefile02/Finance/namedir/IBM/2010/2010
  filename/10 Interm  name's/lll_lllllllllll For name.pdf"
  
  
  Customer/L2 Diagnostics:
  
  The callstack will resemble the following:
  .
  BottomUp(??) at 0x100081c10
  sqlParser_ParseSQL(??, ??, ??, ??) at 0x100081ed8
  sqlQuery_Create(??, ??, ??, ??, ??, ??, ??) at 0x10007a9a0
  AdmSQLExecute(??) at 0x100366d74
  AdmCommandLocal(??, ??, ??, ??, ??) at 0x1001e9e54
  admCommand(??, ??, ??, ??, ??) at 0x1001ead94
  SmAdminCommandThread(??) at 0x100507690
  StartThread(??) at 0x10000e9d8
  
  TSM Versions and Platforms Affected:
  Tivoli Storage Manager V54 and V55 on All supported platforms
  
  Additional keywords:
  
  select  sqlParser BottomUp IC49872
  

Local fix

• Correct the Select Statement to ensure single quote was used to
  enclose the column value.
  

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 levels 5.4.7,  5.5.5, 6.1.5, and 6.2.2.   *
  *                 Note that this is                            *
  *                 subject to change at the discretion of IBM.  *
  ****************************************************************
  On 5.x servers this problem will result in a server abend.  On
  6.x servers this situation will result in a server abend or
  the following diagnostic messages:
  
  ANR9999D_3831306406 ReportSQLDiagInfo(dbieval.c:1293)
  Thread<52>: Missing
  sqlState=42622, sqlCode=-107 from table. Returning rc = 2158.
  
  ANR9999D_0737318079 NewAdmSQLExecute(admsql.c:2453)
  Thread<52>: Unexpected rc
  2158 from tbSQLExecuteSelect.
  

Problem conclusion

• This problem was fixed. Affected platforms:  AIX, HP-UX, Sun
  Solaris, Linux, z/OS, 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

• R54A PSY

     UP

• R54H PSY

     UP

• R54L PSY

     UP

• R54S PSY

     UP

• R54W PSY

     UP

• R54Z PSY

     UP

• R55A PSY

     UP

• R55H PSY

     UP

• R55L PSY

     UP

• R55S PSY

     UP

• R55W PSY

     UP

• R55Z PSY

     UP

• R61A PSY

     UP

• R61H PSY

     UP

• R61L PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP

• R62A PSY

     UP

• R62H PSY

     UP

• R62L PSY

     UP

• R62S PSY

     UP

• R62W PSY

     UP