IC67916: TSM SERVER FAILS TO START AFTER UPGRADE.

APAR status

• Closed as program error.

Error description

• Some tables may not be renamed correctly during an upgrade to
  TSM 6.2.
  
  TSM Versions Affected: All 6.2
  
  Customer/L2 Diagnostics:
  The issue can be confirmed by running dsmserv.exe and looking
  for these messages:
  
  ANR0101E adminit.c(1821): Error XX opening table "XXXX".
  
  - OR -
  
  ANR9999D_1392833238 SetupAdminSQL(adminit.c:6013) Thread<1>:
                      Error XX creating view XXXXX.
  ANR9999D Thread<1> issued message 9999 from:
  ANR9999D Thread<1>  0x00000001000351f0 StdPutText
  ANR9999D Thread<1>  0x00000001000356dc OutDiagToCons
  ANR9999D Thread<1>  0x000000010004728c outDiagfExt
  ANR9999D Thread<1>  0x0000000100bea1e4 SetupAdminSQL
  ANR9999D Thread<1>  0x0000000100bf0a80 admInitPart2
  ANR9999D Thread<1>  0x0000000100bf0e04 admInit
  ANR9999D Thread<1>  0x00000001000088b0 StartServer
  ANR9999D Thread<1>  0x000000010000a360 admStartServer
  ANR9999D Thread<1>  0x000000010000425c main
  ANR9999D_0555130791 admInitPart2(adminit.c:2719) Thread<1>:
                      Error XX setting up admin SQL.
  ANR9999D Thread<1> issued message 9999 from:
  ANR9999D Thread<1>  0x00000001000351f0 StdPutText
  ANR9999D Thread<1>  0x00000001000356dc OutDiagToCons
  ANR9999D Thread<1>  0x000000010004728c outDiagfExt
  ANR9999D Thread<1>  0x0000000100bf0ab8 admInitPart2
  ANR9999D Thread<1>  0x0000000100bf0e04 admInit
  ANR9999D Thread<1>  0x00000001000088b0 StartServer
  ANR9999D Thread<1>  0x000000010000a360 admStartServer
  ANR9999D Thread<1>  0x000000010000425c main
  ANR9999D_0725945475 admInitPart2(adminit.c:2746) Thread<1>:
                      Failure XX during init processing -
                      terminating.
  ANR9999D Thread<1> issued message 9999 from:
  ANR9999D Thread<1>  0x00000001000351f0 StdPutText
  ANR9999D Thread<1>  0x00000001000356dc OutDiagToCons
  ANR9999D Thread<1>  0x000000010004728c outDiagfExt
  ANR9999D Thread<1>  0x0000000100bf0bc0 admInitPart2
  ANR9999D Thread<1>  0x0000000100bf0e04 admInit
  ANR9999D Thread<1>  0x00000001000088b0 StartServer
  ANR9999D Thread<1>  0x000000010000a360 admStartServer
  ANR9999D Thread<1>  0x000000010000425c main
  
  Initial Impact: Medium
  
  Additional Keywords:
  run, upgrade, upgrading, migrate, migrating, migration
  

Local fix

• If ANR0101E adminit.c(1821): Error XX opening table
  "<TableName>".
  messages are seen:
  
  1. Open a DB2 commandline.
  2. Connect to the database instance.
     Example:
     connect to tsmdb1
  3. Issue "db2 rename table <TableName>_bad to <TableName>"
     Example:
     ANR0101E adminit.c(1821): Error XX opening table "nodes".
     db2 rename table TSMDB1.NODES_BAD to NODES
  4. To exit the DB2 commandline, issue "quit".
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users      *
  *                 upgrading their server to a new              *
  *                 server level                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: See error description.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be fixed   *
  *                 in levels 6.1.5 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