切换到实例用户以后不能执行 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 中再切换用户也不行