IC72745: INSERTDB WITH PREVIEW=YES CAN FAIL WITH ANR9999D_3458583819 INSERTATTRIBUTES

APAR status

• Closed as program error.

Error description

• If INSERTDB PREVIEW=YES was specified during upgrade procedure
  of Tivoli Storage Manager server from version 5.x to 6.x,
  processing may stop with "ANR9999D_3458583819 InsertAttributes"
  error.
  
  Insert.log file may look like following:
  
  ANR0408I Session 1 started for server $UPGRADESOURCE$
  (AIX-RS/6000) (Tcp/Ip)
  for V6 Database Upgrade.
  ANR9999D_3458583819 InsertAttributes(tbinsert.c:4719)
  Thread<39>: InsertAttrib-
  ute: Failure 1 processing attribute DRM:413291040.
  ANR9999D Thread<39> issued message 9999 from:
  ANR9999D Thread<39>  0x0000000100012f94 StdPutText
  ANR9999D Thread<39>  0x0000000100013afc OutDiagToCons
  ANR9999D Thread<39>  0x000000010000edbc outDiagfExt
  ANR9999D Thread<39>  0x0000000100a27a64 InsertAttributes
  ANR9999D Thread<39>  0x0000000100a254bc InsertRecords
  ANR9999D Thread<39>  0x0000000100a23418 TbXiInsertThread
  ANR9999D Thread<39>  0x0000000100009d68 StartThread
  ANR9999D_2763589342 InsertRecords(tbinsert.c:3605) Thread<39>:
  Failure 1
  inserting attributes for table DRM.
  ANR9999D Thread<39> issued message 9999 from:
  ANR9999D Thread<39>  0x0000000100012f94 StdPutText
  ANR9999D Thread<39>  0x0000000100013afc OutDiagToCons
  ANR9999D Thread<39>  0x000000010000edbc outDiagfExt
  ANR9999D Thread<39>  0x0000000100a25514 InsertRecords
  ANR9999D Thread<39>  0x0000000100a23418 TbXiInsertThread
  ANR9999D Thread<39>  0x0000000100009d68 StartThread
  ANR9999D_2985131599 tbxiSendVerbToIOThread(tbinsert.c:1745)
  Thread<10>:
  tbXiSendVerbToIOThread:  Failure 10 dispatching verb.
  ANR9999D Thread<10> issued message 9999 from:
  ANR9999D Thread<10>  0x0000000100012f94 StdPutText
  ANR9999D Thread<10>  0x0000000100013afc OutDiagToCons
  ANR9999D Thread<10>  0x000000010000edbc outDiagfExt
  ANR9999D Thread<10>  0x0000000100a21290 tbxiSendVerbToIOThread
  ANR9999D Thread<10>  0x0000000100a1c268 SmV6UpgradeSession
  ANR9999D Thread<10>  0x00000001002a1c28 DoV6Upgrade
  ANR9999D Thread<10>  0x000000010029ac30 smExecuteSession
  ANR9999D Thread<10>  0x0000000100098b08 psSessionThread
  ANR9999D Thread<10>  0x0000000100009d68 StartThread
  ANR0409I Session 1 ended for server $UPGRADESOURCE$
  (AIX-RS/6000).
  ANR1396E INSERTDB: Process 1, database insert, has completed
  with errors.
  
  Tivoli Storage Manager server works as expected therefore
  upgrade without preview is not affected. To confirm this
  problem, ATTRMGR DBCLI DBDUMP trace flags should be used in
  dsmserv.opt options file for server tracing.
  
  TSM Versions Affected:
  Tivoli Storage Manager server 6.x on all platforms.
  
  Initial Impact:
  Low
  
  Additional Keywords:
  zz61 zz62 insertdb InsertAttributes attribute
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  *
  

Problem conclusion

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

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