IBM Support

SQL1031N The database directory cannot be found on the indicated file system

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.

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"7.1","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg21669292