SQL10007N Message “-1390” could not be retrieved. Reason code: “3”

SQL10007N Message “-1390” could not be retrieved.  Reason code: “3”, message pops up while starting the Database. Below is the message,

[root@<hostname> adm]# ./db2start
SQL10007N Message “-1390” could not be retrieved.  Reason code: “3”.

This error message came up after fixing the hostname issue reported in my previous blog entry.

Resolution

1. DB2INSTANCE Environment variable is declared.

On root user, just issue the command, env ,make sure that DB2INSTANCE variable is declared and is visible in the output. If not please assign the variable with the instance name.

ex:

export DB2INSTANCE=<instancename>

export DB2INSTANCE=db2inst1 (my instance name is db2inst1 here)

After export, issue the same command, env and check for the value.

2. Verify db2profile file for all the entries.

Make sure that db2profile file contains all proper entries for the current DB2 instance. db2profile file will be under <instancename>/sqllib/ directory.

3. Make sure that proper access is available to start/stop/query the database. The user with which we are executing the commands should have proper rights with at least 644 privileges.

Please refer to IBM DB2 Support portal technote,

https://www-304.ibm.com/support/docview.wss?uid=swg21474604