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
PM24818
Reported component name
TSM FOR OS/390
Reported component ID
5698ISMVS
Reported release
550
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2010-10-19
Closed date
2010-10-19
Last modified date
2011-12-02
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 FOR OS/390
Fixed component ID
5698ISMVS
Applicable component levels
R550 PSY UK73668
UP11/11/15 P F111
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"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":"550","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
02 December 2011