IBM Support

IC82409: SELECT STATEMENT ON DIRECTORY TABLE RETURNS ERROR ANR0162W AND CLI0109E STRING DATA RIGHT TRUNCATION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Problem Description:
    In a Tivoli Storage Manager Server Command Line (dsmadmc)
    running the following select:
    ANR2017I Administrator TSMBATCH issued command: select DIRECTORY
    from
             DEVCLASSES where DEVCLASS_NAME='FILE_CLASS'
    
    could generate the following error:
    ANR0162W Supplemental database diagnostic information:
    -1:22001:-99999
             ([IBM][CLI Driver] CLI0109E  String data right
             truncation.SQLSTATE=22001).
    ANR0157W Database operation INSERT for table Devclass.SQL failed
    with
             result code 2332 and tracking ID: 11ccf05f8.
    ANR0158W Database operation INSERT for table Devclass.SQL failed
    with
             operation code 2332 and tracking id 11ccf05f8. The data
    for
             column 0 is: (string,
    len=16)0x4449534B504F4F4C2D53312D50524F44
    ANR0102E admsql.c(5357): Error 2332 inserting row in table
    .        "Devclass.SQL".
    
    This is caused by the fact that the column DIRECTORY has 1025
    character length while the file device class definition in field
    directory could contain more than 1025 characters.
    
    Customer/L2 Diagnostics :
    
    For example here we have a File device class with 1143 character
    length in the directory field, gathering a trace with flags
    dbstmt dbexec dbcmd sql, the trace file will shows the
    following:
    -------------------------------------------------
    13:59:28.573 [967646][admsql.c][4594][TsmSqlPrepareData]:Col 11,
    name DIRECTORY, type
    ADMITEM_STRING(1).
    13:59:28.573 [967646][admsql.c][4642][TsmSqlPrepareData]:Col 11,
    string
    "/home/app/tsm/tsmadmin/diskvg-s1-01/01/prod,/home/app/tsm/tsmad
    min/diskvg-s1-01/02/prod,/home/app/t
    sm/tsmadmin/diskvg-s1-01/03/prod,/home/app/tsm/tsmadmin/diskvg-s
    1-01/04/prod,/home/app/tsm/tsmadmin/
    diskvg-s1-01/05/prod,/home/app/tsm/tsmadmin/diskvg-s1-01/06/prod
    ,/home/app/tsm/tsmadmin/diskvg-s1-01
    /07/prod,/home/app/tsm/tsmadmin/diskvg-s1-01/08/prod,/home/app/t
    sm/tsmadmin/diskvg-s1-01/09/prod,/ho
    me/app/tsm/tsmadmin/diskvg-s1-01/10/prod,/home/app/tsm/tsmadmin/
    diskvg-s1-02/01/prod,/home/app/tsm/t
    smadmin/diskvg-s1-02/02/prod,/home/app/tsm/tsmadmin/diskvg-s1-02
    /03/prod,/home/app/tsm/tsmadmin/disk
    vg-s1-02/04/prod,/home/app/tsm/tsmadmin/diskvg-s1-02/05/prod,/ho
    me/app/tsm/tsmadmin/diskvg-s1-02/06/
    prod,/home/app/tsm/tsmadmin/diskvg-s1-02/07/prod,/home/app/tsm/t
    smadmin/diskvg-s1-02/08/prod,/home/a
    pp/tsm/tsmadmin/diskvg-s1-02/09/prod,/home/app/tsm/tsmadmin/disk
    vg-s1-02/10/prod,/home/app/tsm/tsmad
    min/diskvg-s1-03/01/prod,/home/app/tsm/tsmadmin/diskvg-s1-03/02/
    prod,/home/app/tsm/tsmadmin/diskvg-s
    1-03/03/prod,/home/app/tsm/tsmadmin/diskvg-s1-03/04/prod,/home/a
    pp/tsm/tsmadmin/diskvg-s1-03/05/prod
    ,/home/app/tsm/tsmadmin/diskvg-s1-03/06/prod", len 1143.
    13:59:28.633
    [967646][tbcli.c][4234][RdbPrepareAndExecuteStmt]:Executing
    statement 'INSERT INTO
    "TSMDB1"."DEVCLASS_SQL"
    (DEVCLASS_NAME,ACCESS_STRATEGY,STGPOOL_COUNT,DEVTYPE,FORMAT,CAPA
    CITY,MOUNTLIMIT,MOUNTWAIT,MOUNTRETEN
    TION,PREFIX,LIBRARY_NAME,DIRECTORY,SERVERNAME,RETRYPERIOD,RETRYI
    NTERVAL,SHARED,HLADDRESS,MINCAPACITY
    ,WORM,DRIVE_ENCRYPTION,SCALECAPACITY,PRIMARYALLOC,SECONDARYALLOC
    ,COMPRESSION,RETENTION,PROTECTION,EX
    PIRATION,UNIT,LBPROTECT,LAST_UPDATE_BY,LAST_UPDATE)
    VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
    ,?,?) --967646' submitted from
    admsql.c(5357).
    13:59:28.635 [967646][output.c][7227][PutConsoleMsg]:ANR0162W
    Supplemental database diagnostic
    information:  -1:22001:-99999 ([IBM][CLI Driver] CLI0109E
    String data right truncation.
    SQLSTATE=22001).~
    13:59:28.636 [967646][tbcli.c][3856][RdbCliInsert]:Exiting with
    rc=2332
    ----------------------------------------------------------------
    -------
    Tivoli Storage Manager Versions Affected:
    Tivoli Storage Manager Server version  6.x  on all  platforms
    
    Initial Impact:
    Low
    
    Additional Keywords:
     zz61 zz62 zz63 anr1062w CLI0109E 2332
    

Local fix

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 6.2.5 and 6.3.3. Note that         *
    *                 this is subject to change at the discretion  *
    *                 of IBM.                                      *
    ****************************************************************
    *
    

Problem conclusion

  • This problem was fixed.
    The current limit for the directory field in the devclass
    table is 1024 bytes.  If this limit is exceeded then the
    output for this column will be truncated and message
    ANR2900W will be issued indicating that the output for
    this column has been truncated.
    
    Affected platforms:  AIX, HP-UX, Solaris, Linux and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC82409

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    63A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-04-03

  • Closed date

    2012-11-14

  • Last modified date

    2012-11-14

  • 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

  • R62A PSY

       UP

  • R62H PSY

       UP

  • R62L PSY

       UP

  • R62S PSY

       UP

  • R62W PSY

       UP

  • R63A PSY

       UP

  • R63H PSY

       UP

  • R63L PSY

       UP

  • R63S PSY

       UP

  • R63W 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":"63A","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
14 November 2012