IBM Support

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

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

    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:

    PM24818

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



Document information

More support for: Tivoli Storage Manager

Software version: 55W

Reference #: IC71586

Modified date: 20 October 2010


Translate this page: