IBM Support

Tivoli Storage Manager server fails to start after upgrade from V6.2 to V7.1

Troubleshooting


Problem

A Tivoli Storage Manager V6.2.5 server instance running on Windows is upgraded to V7.1.0.0. After the upgrade, the server instance service fails to start.

Symptom

The server instance fails to start in the foreground with the following messages :
ANR0172I rdbinst.c(3757): Error encountered performing action UPDATE DBM CFG
ANR0162W Supplemental database diagnostic information: -1390:**No State Information Available (-2)**:-1390 (SQL1390C The environment variable DB2INSTANCE is not defined or is invalid.).
ANR9999D_3831306406 ReportSQLDiagInfo(dbieval.c:1568) Thread<5>: Missing sqlState= , sqlCode=-1390 from table. Returning rc = 9994.
ANR9999D Thread<5> issued message 9999 from:
ANR9999D Thread<5> 000007FEEBD60825 OutDiagToCons()+155
ANR9999D Thread<5> 000007FEEBD5A75C outDiagfExt()+10c
ANR9999D Thread<5> 000007FEEBAF7930 ReportSQLDiagInfo()+2a0
ANR9999D Thread<5> 000007FEEBAF68F1 DbiEvalSQLOutcomeX()+4f1
ANR9999D Thread<5> 000007FEEBA8423A RdbCreateConnection()+49a
ANR9999D Thread<5> 000007FEEBA82AAD DbiGetConnectionTracked()+18d
ANR9999D Thread<5> 000007FEEBB01F19 RdbDeactivateDatabaseThread()+129
ANR9999D Thread<5> 000007FEEB48707C startThread()+13c
ANR9999D Thread<5> 000007FEF90A3FEF beginthreadex()+107
ANR9999D Thread<5> 000007FEF90A4196 endthreadex()+192
ANR9999D Thread<5> 0000000076D6F56D BaseThreadInitThunk()+d
ANR9999D Thread<5> 0000000076FA3021 RtlUserThreadStart()+21
ANR0162W Supplemental database diagnostic information: -1: :-1390

Diagnosing The Problem

Verify which account is configured to run the following server instance services :

  • TSM Server1
  • DB2 - DB2TSM1 - SERVER1

In this case, the server1 instance services were configured to run under the "Local System" account and only the "Local System" was configured to access the instance database.

Resolving The Problem

To resolve this issue, you must log on as the "Local System" account and grant authority to the appropriate instance user ID. Complete the following steps for Windows 2008 and later:

  • Download and install Windows utility called psexec.exe:
    http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx
  • Open cmd.exe
  • Navigate to the location of psexec.exe and run the following command:
    PSEXEC -i -s -d db2cmd.exe
    You are now logged in as SYSTEM
  • Navigate to the location of db2cmd.exe and run the following commands :
    set db2instance=server1
    db2 connect to TSMDB1
    db2 grant dbadm with dataaccess with accessctrl on database to user XXX
    db2 grant secadm on database to user XXX

In the two grant commands, XXX is the user ID from which the Tivoli Storage Manager server is to be run (different than the "Local System" account).

When the user ID has special characters such as "." and "\" , you must surround the user ID with quotation marks and use the escape character before each quotation mark. For example, the following command fails :
db2 grant dbadm with dataaccess with accessctrl on database to user "my.user"
The following error is reported :
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0104N An unexpected token "." was found following "database to user svc". Expected tokens may include: ",". SQLSTATE=42601
The correct syntax for the command is:
db2 grant dbadm with dataaccess with accessctrl on database to user \"my.user\"

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg21669195