linux看是不是db2实例用户,切换到实例用户以后不能执行 db2

切换到实例用户以后不能执行 db2

在linux下安装了db2 express ,但是在切换到实例用户以后不能执行db2命令；-sh-3.2$ su - db2inst1

Password:

-sh-3.2$ db2

-sh: db2: command not found

这是环境变量的问题，随后检查export输出

-sh-3.2$ export

export CVS_RSH="ssh"

export G_BROKEN_FILENAMES="1"

export HISTSIZE="1000"

export HOME="/home/db2inst1"

export HOSTNAME="localhost.localdomain"

export INPUTRC="/etc/inputrc"

export LANG="en_US.UTF-8"

export LESSOPEN="|/usr/bin/lesspipe.sh %s"

export LOGNAME="db2inst1"

export LS_COLORS="no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:"

export MAIL="/var/spool/mail/db2inst1"

export OLDPWD

export PATH="/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin"

export PWD="/home/db2inst1"

export SHELL="/bin/sh"

export SHLVL="1"

export SSH_ASKPASS="/usr/libexec/openssh/gnome-ssh-askpass"

export TERM="xterm"

export USER="db2inst1"

随后手工执行. /home/db2inst1/sqllib/db2profile

export 输出

-sh-3.2$

-sh-3.2$ export

export CLASSPATH="/home/db2inst1/sqllib/java/db2java.zip:/home/db2inst1/sqllib/java/db2jcc.jar:/home/db2inst1/sqllib/java/sqlj.zip:/home/db2inst1/sqllib/function:/home/db2inst1/sqllib/java/db2jcc_license_cu.jar:."

export CVS_RSH="ssh"

export DB2INSTANCE="db2inst1"

export G_BROKEN_FILENAMES="1"

export HISTSIZE="1000"

export HOME="/home/db2inst1"

export HOSTNAME="localhost.localdomain"

export INPUTRC="/etc/inputrc"

export LANG="en_US.UTF-8"

export LD_LIBRARY_PATH="/home/db2inst1/sqllib/lib32"

export LESSOPEN="|/usr/bin/lesspipe.sh %s"

export LOGNAME="db2inst1"

export LS_COLORS="no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:"

export MAIL="/var/spool/mail/db2inst1"

export OLDPWD="/home/db2inst1/sqllib"

export PATH="/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/db2inst1/sqllib/bin:/home/db2inst1/sqllib/adm:/home/db2inst1/sqllib/misc:/home/db2inst1/sqllib/db2tss/bin"

export PWD="/"

export SHELL="/bin/sh"

export SHLVL="1"

export SSH_ASKPASS="/usr/libexec/openssh/gnome-ssh-askpass"

export TERM="xterm"

export USER="db2inst1"

再次输入db2正常

-sh-3.2$ db2

(c) Copyright IBM Corporation 1993,2007

Command Line Processor for DB2 Client 9.7.0

版本信息

LSB Version:    :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarch

Distributor ID: RedHatEnterpriseServer

Description:    Red Hat Enterprise Linux Server release 5.3 (Tikanga)

Release:        5.3

Codename:       Tikanga

在linux系统中，为DB2 默认创建的用户db2inst1，不需要任何设置，应该可以直接使用db2命令,这是什么原因，path设置的问题，还是？

默认用户的path是系统自动添加的？把. /home/db2inst1/sqllib/db2profile 添加到.bash_profile 中再切换用户也不行