IBM Support

PM24818: ANR2914E SQL IDENTIFIER TOKEN EXCEEDS 18 CHARACTERS AFTER UPDATE TO TIVOLI STORAGE MANAGER SERVER V5.5.5

A fix is available

Subscribe

You can track all active APARs for this component.

 

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:

    IC71586

  • 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