IBM Support

DBI1306N The instance profile is not defined

Troubleshooting


Problem

The Tivoli Storage Manager Server instance fails to start with the DBI1306N error.

Cause

Incorrect DB library links

Environment

Tivoli Storage Manager Server on Linux/Unix

Diagnosing The Problem

Follow the steps below to diagnose the problem.
1. Logon with the instance userid and run the following DB2 commands :

db2start
db2 connect to tsmdb1

The above commands finish successfully.

2. The db2iupdt command fails with the following error although there is nothing accessing the instance :

/opt/tivoli/tsm/db2/instance/db2iupdt instance_name

DBI1250E Applications are still using instance tsmadm.

3. Running the db2set command as the instance owner fails with the DBI1306N error but the same command as root returns the correct information.

4. Running the db2level command as the instance owner returns an incorrect installation path (/usr). For example :

DB21085I Instance "tsmadm" uses "64" bits and DB2 code release "SQL09074" with
level identifier "08050107".
Informational tokens are "DB2 v9.7.0.4", "s110330", "IP23236", and Fix Pack "4".
Product is installed at "/usr".

Running the same db2level command as root returns the correct information.

5. The instance owner uses the following LIBPATH environment variable :

LIBPATH=/usr/lib:/lib:/home/tsmadm/sqllib/lib64


6. There are db2 libraries under /usr/lib pointing to the 32-bit libraries. For example :

ls -al /usr/local/*db2*

lrwxrwxrwx 1 root system 34 May 16 14:06 libdb2.a ->/opt/tivoli/tsm/db2/lib32/libdb2.a
lrwxrwxrwx 1 root system 40 May 16 14:06 libdb2dascmn.a -> /opt/tivoli/tsm/db2/lib32/libdb2dascmn.a
lrwxrwxrwx 1 root system 38 May 16 14:06 libdb2g11n.a -> /opt/tivoli/tsm/db2/lib32/libdb2g11n.a
lrwxrwxrwx 1 root system 40 May 16 14:06 libdb2genreg.a ->/opt/tivoli/tsm/db2/lib32/libdb2genreg.a
lrwxrwxrwx 1 root system 41 May 16 14:06 libdb2install.a -> /opt/tivoli/tsm/db2/lib32/libdb2install.a
lrwxrwxrwx 1 root system 40 May 16 14:06 libdb2locale.a -> /opt/tivoli/tsm/db2/lib32/libdb2locale.a
lrwxrwxrwx 1 root system 38 May 16 14:06 libdb2osse.a -> /opt/tivoli/tsm/db2/lib32/libdb2osse.a
lrwxrwxrwx 1 root system 42 May 16 14:06 libdb2osse_db2.a -> /opt/tivoli/tsm/db2/lib32/libdb2osse_db2.a
lrwxrwxrwx 1 root system 40 May 16 14:06 libdb2trcapi.a -> /opt/tivoli/tsm/db2/lib32/libdb2trcapi.a

Resolving The Problem

Because the /usr/lib is configured first in the LIBPATH environment variable, the 32-bit db2 libraries or libraries under /opt/tivoli/tsm/db2/lib32 are called. The correct libraries should be the 64-bit libraries.

Because "/home/tsmadm/sqllib/lib64" is in the LIBPATH environment variable, the db2 library links under /usr/local are not required. To resolve the issue, run the below command to remove the unnecessary links :

rm /usr/local/*db2*

[{"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":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg21673882