TSM server cannot bring up after OS upgrade

fadzlirot

ADSM.ORG Member
Joined
Jan 21, 2015
Messages
52
Reaction score
1
Points
0
PREDATAR Control23

Hi,

We have a project to upgrade TSM server from 7.1 to 8.1.
First wintel team have upgrade the server from windows 2008 to windows 2016.
After the OS upgrade i try to bring up the server first before upgrade but receive this error instead:

ANR0900I Processing options file C:\Program Files\Tivoli\TSM\SERVER1\dsmserv1.-
opt.
ANR4726I The ICC support module has been loaded.
ANR0990I Server restart-recovery in progress.
ANR0172I rdbinst.c(3867): Error encountered performing action UPDATE DBM CFG.
ANR0162W Supplemental database diagnostic information: -1042:SQLSTATE 58004: A
system error (that does not necessarily preclude the successful execution of
subsequent SQL statements) occurred.
:-1042 (SQL1042C An unexpected system
error occurred. SQLSTATE=58004
).
Entering exception handler.
Leaving exception handler.
 
PREDATAR Control23

Correction: Windows upgrade from 2008 to 2012r2
 
PREDATAR Control23

I do hope you have a backup of the TSM DB.

Try this in order:

1. Restore the TSM DB. If this works, update to TSM 8.1; if this does not work, proceed with 2 below.
2. Try reinstalling TSM 7.1 and do a restore of the TSM DB. Once this is running, update to TSM 8.1.
 
PREDATAR Control23

HI just for update. This is fixed. The crash is caused because the hostname changed after the OS upgrade.

Here i share how it is resolved by IBM support:


1) If "DB2 Command Window - Administrator" could not be opened, please switch to
C:\Program Files\Tivoli\TSM\db2\BIN to run the db2 commands

2) the output of run any db2 commands, showing :
"SQL1022C There is not enough memory available to process the command"
It is due to hostname has been changed after upgrading from 2008 to 2012

Error "SQL1022C There is not enough memory available to process the command" after changing hostname of the DB2 server.
https://www.ibm.com/support/pages/e...ss-command-after-changing-hostname-db2-server


Resolving The Problem :
If you change the computer name, and the computer groups DB2ADMNS and DB2USERS are local computer groups, you must update the DB2_ADMINGROUP and DB2_USERSGROUP global registries. To update the registry variables after renaming and restarting the computer run the following command:
Open a command prompt.
Run the db2extsec command to update security settings:
db2extsec -a new computer name\DB2ADMNS -u new computer name\DB2USERS

After that, then rebooted machine and db2 back to normal and SP server is running well.
However, dsmadmc command still failed to access SP server.

3) checked dsm.opt file and have found that the server ip address has also been changed after upgrading OS. After modifying tcpserveraddress in the dsm.opt then dsmadmc can be used to access SP server.
 
PREDATAR Control23

Why would the hostname and IP address be changed? There must be an error with the update process. I had done a lot of in place updates with Windoze and never had this issue.
 
PREDATAR Control23

The hostname change is part of the OS upgrade plan. What i am not aware of is that it will cause problem to TSM. Hence why i did not include the info in the initial question. Sorry for the confusion
 
Top