A fix is available
APAR status
Closed as program error.
Error description
Issuing select statements against the Tivoli Storage Manager Server database from the administrative command line interface where the SQL column identifier token (the given name for a column) is longer than 18 characters will result in the following message in thi activity log: ANR2017I Administrator ADMIN issued command: select 999 - count(*) as "Free Slots at Library [999 Summary]:" from libvolumes (SESSION: 123) ANR2914E SQL identifier token 'Free Slots at Library [999 Summa' is too long; name or component exceeds 18 characters. (SESSION: 123) Platforms and versions affected: Tivoli Storage Manager 5.5.5 on all supported platforms Initial Impact: Low Additional Keywords: tsm select sql report
Local fix
Local Fix: Modify select statements to have a column identifier shorter than 18 characters until a fix is available.
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.1 and 5.5.6. Note * * that this is * * subject to change at the discretion of IBM. * **************************************************************** *
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
IC71586
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
55W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-10-01
Closed date
2010-10-04
Last modified date
2010-10-20
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
R55A PSY
UP
R55H PSY
UP
R55L PSY
UP
R55S PSY
UP
R55W PSY
UP
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"55W"}]
Document Information
Modified date:
17 September 2021