By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,752 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

Connecting to database server through CLP

P: n/a
Hi All:

I use db2 v8.1 fixpack 3 on AIX 5.2
After I login to my database server if i fire the command db2 it gives
me the following error message:

SQL10007N Message "-1390" could not be retrieved. Reason code: "1"

How ever i fire the comand

export DB2INSTANCE=<"instance name">
using the root login
and then try command db2 it works.
Can some plz advice me on how to the manual entry of the export
command evrytime i login.
Regards,
Racerx.

Feb 6 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Racerx wrote:
Hi All:

I use db2 v8.1 fixpack 3 on AIX 5.2
After I login to my database server if i fire the command db2 it gives
me the following error message:

SQL10007N Message "-1390" could not be retrieved. Reason code: "1"

How ever i fire the comand

export DB2INSTANCE=<"instance name">
using the root login
and then try command db2 it works.
Can some plz advice me on how to the manual entry of the export
command evrytime i login.
It seems to me as if you haven't sources the sqllib/db2profile before
attempting to connect to DB2.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Feb 6 '07 #2

P: n/a
You shouldn't really be "doing working" as root. Perhaps a good idea
to create an alternative user.
Then you can stick something like this into your .profile file in your
users home directory.

if [ -f /home/db2inst1/sqllib/db2profile ]; then
. /home/db2inst1/sqllib/db2profile
fi

This will setup the required environment variables for DB2.

Feb 7 '07 #3

P: n/a
On Feb 7, 2:25 pm, "Otto Carl Marte" <Otto.Ma...@gmail.comwrote:
You shouldn't really be "doing working" as root. Perhaps a good idea
to create an alternative user.
Then you can stick something like this into your .profile file in your
users home directory.

if [ -f /home/db2inst1/sqllib/db2profile ]; then
. /home/db2inst1/sqllib/db2profile
fi

This will setup the required environment variables for DB2.
Thx a lot that helped.

Feb 7 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.