Connecting to database server through CLP

[Racerx]

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.

[Knut Stolze]

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

[Otto Carl Marte]

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.

[Racerx]

On Feb 7, 2:25 pm, "Otto Carl Marte" <[e-mail]:

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.