• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.


    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

TSM server cannot bring up after OS upgrade



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.-
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.


ADSM.ORG Moderator
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.


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.

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.


ADSM.ORG Moderator
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.


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

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 18 18.6%
  • Keep using TSM for Spectrum Protect.

    Votes: 59 60.8%
  • Let's be formal and just say Spectrum Protect

    Votes: 12 12.4%
  • Other (please comement)

    Votes: 8 8.2%

Forum statistics

Latest member