IBM Support

The IBM Spectrum Protect server might not start after upgrade to 8.1.12



The IBM Spectrum Protect server might not start after upgrade to 8.1.12 if the server previously was used at a level of It does not matter what level was upgraded from, only if the server at one time was used at an level.


After upgrading to 8.1.12, the server could fail to start with the following symptom:
ANR9999D_4269667813 AdmSetupAdminSQL(adminit.c:9330) Thread<1>: Error 4208
creating table RETSETSIT.
ANR9999D Thread<1> issued message 9999 from:
ANR9999D Thread<1>  0x0000000100037c00 StdPutText
ANR9999D Thread<1>  0x0000000100038e6c OutDiagToCons
ANR9999D Thread<1>  0x000000010000d028 outDiagfExt
ANR9999D Thread<1>  0x0000000100f14434 AdmSetupAdminSQL
ANR9999D Thread<1>  0x0000000100182bb4 IPRA.$StartServer
ANR9999D Thread<1>  0x0000000100181660 admStartServer
ANR9999D Thread<1>  0x0000000100001780 main
This can happen if the server was used at an ( where xxx can be any value including 0) server level.
The admin command SHOW VERSIONHISTORY can be used to determine if the server was ever used at that maintenance level.
If the server is not running due to the upgrade this can be checked with:
db2 "select * from tsmdb1.db_info"
Here is a sample line showing an 8.1.9 level:
2020/04/23 05:20:45 08,01,09,300,000,201011214 100
The following commands can be used to drop the table that is causing the failure.  There is no data loss deleting this table since it is a temporary table.
db2 connect to tsmdb1
db2 drop table tsmdb1.retsetsti
db2 terminate
NOTE:  The table name being dropped is slightly different than the one being created.  The one being dropped has an index by the same name as the one being created causing this issue.  The table being dropped is an unused temporary table.

[{"Type":"SW","Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEQVQ","label":"IBM Spectrum Protect"},"ARM Category":[{"code":"a8m0z000000GpJXAA0","label":"Server->Install"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1.12"}]

Document Information

Modified date:
03 May 2021