IBM Support

IC89623: GENERATE BACKUPSET COMMAND MAY FAIL DURING INSERT FOR TABLE BACKUPSET.TEMP.OBJECTS WITH RESULT CODE 2332

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • GENERATE BACKUPSET command may fail with following error:
    
    ANR0162W Supplemental database diagnostic information:
    -1:22001:-99999
    ([IBM][CLI Driver] CLI0109E  String data right truncation.
    SQLSTATE=22001). (SESSION: 13572, PROCESS: 257)
    ANR0157W Database operation INSERT for table
    Backupset.Temp.Objects
    failed with result code 2332 and tracking ID: 000000001F576190.
    (SESSION: 13572, PROCESS: 257)
    
    Server DBCMD DBSTMT trace will show following:
    
    11:00:34.680
    [51][tbcli.c][10372][TraceSetInputParameters]:col=21,
    name=BKSET_GRPINFO, type=STRING(BIN),
    value=(1593)c'......1y3........7................y[.......P......
    ....................yq.......\........\.........+.......W.......
    ...........q......~'-0x'020000000017317933020000000016fde9370200
    00000016f91810020000000016f5795b020000000016f1501c020000000016ee
    f6b4020000000016eb1fe4020000000016e97971020000000016e55c7f020000
    000016e45c2e020000000016a6c12b0200000000168857df02000000001684ff
    f402000000001682d6710200000000167efaad0200000000'
    
    11:00:34.681
    [51][tbcli.c][4283][RdbPrepareAndExecuteStmt]:Executing
    statement 'INSERT INTO
    "SESSION"."BKSETOBJS"(BKSET_NODENAME,BKSET_DATAT
    YPE,BKSET_FSNAME,BKSET_FSTYPE,BKSET_DIRDELIM,BKSET_OBJTYPE,BKSET
    _HLID,BKSET_LLID,BKSET_OBJID,BKSET_HL,BKSET_LL,BKSET_SEQNO,BKSET
    _OFFSET,BKSE
    T_VOLINDEX,BKSET_POSITION,BKSET_INSDATE,BKSET_OBJINFO,BKSET_GRPT
    YPE,BKSET_GRPOBJID,BKSET_GRPLEADER,BKSET_GRPCOUNT,BKSET_GRPINFO,
    BKSET_INCLUD
    ED) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)'
    submitted from imobjgen.c(6846).
    11:00:34.682 [51][output.c][7271][PutConsoleMsg]:ANR0162W
    Supplemental database diagnostic information:  -1:22001:-99999
    ([IBM][CLI Driver]
    CLI0109E  String data right truncation. SQLSTATE=22001).~
    
    This is caused by the groupinfo field being too long (1593),
    which is greater than the limit (1536).
    
    TSM Versions Affected:
    Tivoli Storage Manager V6 server on all platforms.
    
    Initial Impact:
    Low
    
    Additional Keywords:
    TSM generate backupset ANR0162W ANR0157W CLI0109E
    Backupset.Temp.Objects
    

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

Problem conclusion

  • This problem was fixed.
    Affected platforms:  AIX, HP-UX, Solaris, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89623

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    63W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2013-01-21

  • Closed date

    2014-04-10

  • Last modified date

    2016-02-15

  • 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

  • R63A PSY

       UP

  • R63H PSY

       UP

  • R63L PSY

       UP

  • R63S PSY

       UP

  • R63W PSY

       UP

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 63W

Reference #: IC89623

Modified date: 15 February 2016