db2 command not found in unix

Question

I am trying to execute a simple db2 command in Linux command prompt. but Linux command prompt is not recognizing the command it is giving - bash db2 command not found. but db2 is installed in the Linux machine.

command I am trying to execute from Linux command line processor is db2 "create database smaple"

Error I am getting is below "If db2 in not a typo you can run the following command to lookup the package that contains the binary" command-not-found db2 -bash: db2: command not found"

Is this because of environment variable problem ?? or there is only one instance of db2 ie db2inst1 is running in the machine.my user name in appsusr and db2 instance name is db2inst1 are different is this causing problem?? and I am not having super user access.Is this is causing any problem?? do I need super user access is required ??

Answer 1

Just type, echo $PATH in your command prompt , where you can see all the exported paths in your system.

If the db2 path is not found in your environment variable list, then do the following.

export PATH=$PATH:/opt/IBM/db2/V10.1/bin

and then press enter. I hope this will resolve your issue.

Answer 2

On Linux and UNIX DB2 platforms, the proper way to set your environment variables to run DB2 commands is to source the sqllib/db2profile script belonging to the local DB2 instance owner. That will set not only your PATH but also other important variables that DB2 requires.

In your case, the instance is owned by the db2inst1 user, so your login startup file or batch script should run this command:

. ~db2inst1/sqllib/db2profile

The leading dot is necessary to set the variables in your current shell process, not the sub-process that quickly vanishes after db2profile finishes.