Troubleshooting
Problem
After upgrading the Tivoli Storage Manager server to V7.1, the server fails to start and logs the SQL1031N error.
Symptom
The following errors are logged :
ANR0172I rdbdb.c(2272): Error encountered performing action ActivateDatabase.
ANR0162W Supplemental database diagnostic information: -1031:SQLSTATE 58031: The connection was unsuccessful, because of a system error. :-1031 (SQL1031N The database directory cannot be found on the indicate file system. SQLSTATE=58031).
Environment
Tivoli Storage Manager Server V7.1 on UNIX/Linux
Diagnosing The Problem
1: Verify the Tivoli Storage Manager Server code is upgraded using the following command :
/opt/IBM/InstallationManager/eclipse/tools/imcl listInstalledPackages
This command should show that the Tivoli Storage Manager Server is at version 7.x.
2: Verify that DB2 is upgraded using the following command :
/opt/tivoli/tsm/db2/adm/db2licm -l
This command should show the following :
Product name: "DB2 Enterprise Server Edition"
License type: "Restricted"
Expiry date: "Permanent"
Product identifier: "db2ese"
Version information: "10.x
3: Verify that the instance exists using the following command :
/opt/tivoli/tsm/db2/instance/db2ilist
This command should should return the name of the instannce. For example, "tsminst1".
If the db2ilist command does not show the instance name, run db2icrt to create the instance with the original setting before proceeding further.
4: Switch to the instance userid and verify the database directory. For example :
su - tsminst1
db2 list db directory
In this case, the command returns no output.
Resolving The Problem
Login as the instance owner and follow the steps below to resolve the issue
1: Manually catalog the database using the below commands :
db2 catalog database tsmdb1 as TSMAL001 at node TSMNODE1
db2 catalog db tsmdb1 on /db_path
Note :
/db_path is the database location which shows in "db2 list db directory". For example :
/home/tsminst1/tsminst1
2: Manually upgrade the database using the below command :
db2 upgrade db tsmdb1
Note: this command may take a while to finish. You can monitor the process via the instance db2diag.x.log file.
3: Start the Tivoli Storage Manager Server using the below command :
/opt/tivoli/tsm/server/bin/dsmserv
Note:
During the first start after the upgrade, it may take a bit longer for the server to start because of the database schema changes that are done.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21669292