When I log in to AIX/Unix box and if I try to run DB2 command it fails with following message
"ksh: db2: not found"
This is becauase the DB2 user profile is not loaded into your shell environment. To load it automatically whenever you login, you need to edit your ".profile" file. Below are the step for the same. This is very similar to window DOS environment setup with environment variables and set path etc.
type "vi .profile" in the console window. vi editor should open up with the contents of the .profile file. After the vi is open, it's in command mode, so whatever you type it will not be visible on the screen. By chance you some some valid vi command you will see some action else nothing will be happening.
In my case here is how it looks like, just so that you know how the vi editor looks like
You can refer to below URL for vi commands. With the help of vi command you should be able to put the following text into the .profile that you have opened.
# The following three lines have been added by UDB DB2.
if [ -f /home/db2inst1/sqllib/db2profile ]; then
. /home/db2inst1/sqllib/db2profile
fi
Or you may want to just copy above line and just paste it {ESC}i and right click with a mouse(assuming the contents are in the clipboard)
After you are done with editing enter ":wq" command to save and quit the editor.
For this profile change to take effect you need to log-off and log back in. When you log back in, try db2 and it should take you to DB2 prompt.
Hope this serves some help to people who are new to DB2 and coming from windows background like I do.
