IC66204: RECEIVING ERROR DURING INSERTDB PROCESS, STRING LENGTH OF XX EXCEEDS THE MAXIMUM OF 33

APAR status

• Closed as program error.

Error description

• Running InsertDB to upgrade Tivoli Storage Manager Server to
  V61, the process received the following messages:
  
  ANR9999D_3176249032 tbNetDecodeCols(tbcol.c:1579) Thread<33>:
  Right truncation occured while decoding string data for column
  18 in table Legacy.Backup.Objects. String length of 36 exceeds
  the maximum of 33 (twoBuf val 36).
  ANR9999D Thread<33> issued message 9999 from:
  ANR9999D Thread<33>  0x0000000100012440 StdPutText
  ANR9999D Thread<33>  0x0000000100012cfc OutDiagToCons
  ANR9999D Thread<33>  0x000000010000e51c outDiagfExt
  ANR9999D Thread<33>  0x000000010007f47c tbNetDecodeCols
  ANR9999D Thread<33>  0x00000001009fe848 InsertRecords
  ANR9999D Thread<33>  0x00000001009fd7d0 TbXiInsertThread
  ANR9999D Thread<33>  0x00000001000094a4 StartThread
  
  
  In Tivoli Storage Manager V55, the Backup.Object table column 18
  can accept a string up to 64 characters, while the same column
  in V61's Backup.Objects table  has a constrain of 33 characters.
  The objects in V55 Backup.Object table which column 18 greater
  than 33 characters will receive above errors during upgrade.
  
  Platform/Version affected
  Tivoli storage Manager server V6.1 on all supported platform
  
  Additional keyword:
   zz61 insertdb upgrade db tbNetDecodeCols ANR1338E constrnt
  
  Initial Impact:
  High
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users with *
  *                                                              *
  *                 NAS backups.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Tivoli Storage Manager server users who *
  *                                                              *
  *                      use NAS backups may encounter database  *
  *                      errors when upgrading to V6.1 or V6.2,  *
  *                      or when backing up a NAS node to a      *
  *                      Tivoli Storage Manager V6.1 or V6.2     *
  *                      server.  To date, this has only been    *
  *                      observed with the following NAS filers  *
  *                                                              *
  *                      - BlueArc Titan 2100                    *
  *                        Software Version:  6.0.1533.33        *
  *                                                              *
  *                      but other filers might encounter the    *
  *                      same errors.                            *
  *                                                              *
  *                      *  Note that BlueArc is a registered    *
  *                      trademarks of the BlueArc Corporation.  *
  ****************************************************************
  * RECOMMENDATION: Apply the fixing level when available. This  *
  *                 problem is currently projected to be fixed   *
  *                 in levels 6.1.4 and 6.2.2.  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, and
  Windows.
  

Temporary fix

Comments

APAR Information

• 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

• R61A PSY

     UP

• R61H PSY

     UP

• R61L PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP

• R62A PSY

     UP

• R62H PSY

     UP

• R62L PSY

     UP

• R62S PSY

     UP

• R62W PSY

     UP