为DB2 新增加的用户不能直接使用db2命令的解决办法

在linux系统中，为DB2 默认创建的用户db2inst1，不需要任何设置，可以直接使用db2命令，而后来新建的其他用户，比如说test，test执行db2命令时，就会报找不到。解决办法是，打开/home/test/.bashrc，命令是$ cd /home/test  $ vi .bashrc，然后粘贴下面的代码

 

# The following three lines have been added by UDB DB2.
if [ -f /home/db2inst1/sqllib/db2profile ]; then
    . /home/db2inst1/sqllib/db2profile
fi

 

保存退出后，再输入db2进行测试。

[root@localhost ~]# su - test
[test@localhost ~]$ db2
(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 9.7.0

You can issue database manager commands and SQL statements from the command
prompt. For example:
    db2 => connect to sample
    db2 => bind sample.bnd

For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
 ? CATALOG DATABASE for help on the CATALOG DATABASE command
 ? CATALOG          for help on all of the CATALOG commands.

To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.

For more detailed help, refer to the Online Reference Manual.

db2 =>

 

输出以上内容说明，test用户可以正常使用db2命令了。