DB2START can fail, reporting SQL1390C, for various reasons.
The db2start command will fail with the following error message:
SQL10007N Message "-1390" could not be retrieved. Reason code: "3"
The problem can be due to several reasons. The common culprits are:
- Incorrect DB2INSTANCE environment variable setting.
- The db2profile has not be sourced properly.
- Inconsistencies in /etc/group or /etc/passwd
Resolving The Problem
First, it is a good idea to run db2iupdt as the root user if you're receiving this error message. If db2start continues to fail you should check the following:
- The "DB2INSTANCE" environment variable should be set to the instance name of the instance you wish to start. You can check this value by running "env".
- On UNIX and Linux the db2profile should be sourced properly (db2cshrc for C shell). This may mean the user's profile contains a command similar to:
- If you're on AIX and receiving this message you should check the password algorithm being used for the user. The sha256 algorithm, for example, is not supported in DB2 V9.1 (at V9.5 Fix Pack 4 it is). You can check the password rules for each DB2 version in the respective Information Center.
- Check the "id" output of the user running db2start. Then, check to make the user and user's group exist in the /etc/passwd and /etc/group files respectively. Make sure permissions correctly set (at least 644).
16 June 2018