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 number
IC67916
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
62W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-04-16
Closed date
2010-05-14
Last modified date
2010-10-12
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
[{"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":"62W","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
12 October 2010