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 number
IC68102
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
55A
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-04-22
Closed date
2010-05-25
Last modified date
2010-05-26
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"55A","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
26 May 2010