设置primary group和 Group Set的设置
primary group:
db2grp1
Group Set选择这些组:db2grp1,system,staff,adm,security,mqm,mqbrkrs,dasadm1,db2fgrp1,oinstall,dba
在
db2inst1的用户目录下,修改/home/db2inst1/.profile的内容如下:
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:/usr/opt/db2_08_01/bin:.
export PATH
export ODBCINI=/var/mqsi/odbc/.odbc.ini
if [ -s "$MAIL" ]
# This is at Shell startup. In normal
then echo "$MAILMSG"
# operation, the Shell checks
fi
# periodically.
# The following three lines have been added by UDB DB2.
if [ -f /home/db2inst1/sqllib/db2profile ]; then
. /home/db2inst1/sqllib/db2profile
fi
. /opt/IBM/mqsi/6.0/bin/mqsiprofile
LC_FASTMSG=false
LIBPATH=$LIBPATH:/usr/java14/jre/bin/classic:/usr/mqm/lib:/opt/IBM/mqsi/6.0/merant/lib:/opt/IBM/mqsi/6.0/lib
MQSI_REGISTRY=/var/mqsi
export LC_FASTMSG LIBPATH MQSI_REGISTRY
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle
NLS_LANG=AMERICAN_AMERICA.UTF8
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
LIBPATH=/usr/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$LIBPATH
LIBPATH_64=/usr/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/lib
PATH=$ORACLE_HOME/bin:/home/oracle/bin:$PATH
ORA_NLS10=$ORACLE_HOME/nls/data
export PATH ORACLE_BASE ORACLE_HOME NLS_LANG LD_LIBRARY_PATH LIBPATH LIBPATH_64 ORA_NLS10
创建用户的数据库实例
( 如安装db2数据库时成功创建db2inst1实例,可以不执行以下操作)
在命令行:
cd /usr/opt/db2_08_01/instance
./db2icrt –u db2fenc1 db2inst1