New user creation on linux but not able to access db2

Posted by Pawan at July 24. 2008

Hi All,
There is running db2 on my linux server. I created a new user on this server.
When i logged in by new user, not able to find db2.
on command prompt it throws "command not found"

[db2select@ibmuat3 ~]$ db2
-bash: db2: command not found

what i need to do for accessing db2 by this new user...
please reply ASAP

Thanks
Pawan

Re: New user creation on linux but not able to access db2

Posted by perallis at July 28. 2008

Add the db2profile path in the home directory of the new user

$ vi .profile

Hello Pawan,

You just need to add the db2profile path in the home directory of the new user the db2profile, see the steps below:

$ vi .profile

Add in you .profile the lines below:

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

. /home/db2inst1/sqllib/db2profile --//this is the db2profile path

check your instance home directory

fi

When you login next time, you will get to execute the db2 commands

Re: New user creation on linux but not able to access db2

Posted by Pawan at July 28. 2008

if i use profile of another user then will not create any problem?

Re: New user creation on linux but not able to access db2

Posted by Saurabh at August 21. 2008

If the other user is able to connect, you would find the same statements as mentioned by perallis

DBA to DBA

Personal tools

Document Actions

New user creation on linux but not able to access db2