Tales of a Linux/DB2 Noob

So I tried to install DB2 8.2 on Fedora 8 recently. The install seemed to go smoothly, but then I couldn’t really do anything. Running any DB2 command (like ‘db2′) would give strange errors like:
SQL10007N Message “-1390″ could not be retrieved.  Reason code: “3″.
and
./db2cc: line 26: db2javit: command not found
and
DB2JAVIT : RC = 9501DB2INSTANCE : -2029059916

After searching the web and trying a number of things with no better results, I tried logging in as the db2inst1 user created during installation. Voila! Everything works beautifully. The thing that I was missing for using DB2 commands from other users was adding DB2 environment variables. The script that does this in a default installation is /home/db2inst1/sqllib/db2profile. Running the following command sets up the DB2 environment:
. /home/db2inst1/sqllib/db2profile

Okay, this is probably a total noob mistake, but if this post helps just one person, it was worth it.  

Post a Comment

You must be logged in to post a comment.