创建用户
/usr/sbin/groupadd db2iadm1/usr/sbin/groupadd db2fadm1
/usr/sbin/useradd -m -g db2iadm1 -d /home/db2inst1
/usr/sbin/useradd -m -g db2iadm1 -d /home/db2inst1 db2inst1
/usr/sbin/useradd -m -g db2fadm1 -d /home/db2fenc1 db2fenc1
创建实例
/opt/ibm/db2/V10.1/instance/db2icrt -a server -u db2fenc1 db2inst1
产品许可证
/opt/ibm/db2/V10.1/adm/db2licm -a /tmp/expc/db2/license/db2expc_uw.lic
允许SMS的多页分配
/opt/ibm/db2/V10.1/cfg/db2ln
vi /etc/services
add db2inst1 50000/tcp
DB2 配置
su - db2inst1
db2set DB2_EXTENDED_OPTIMIZATION=ON
db2set DB2_DISABLE_FLUSH_LOG=ON
db2set AUTOSTART=YES
db2set DB2_STRIPED_CONTAINERS=ON
db2set DB2_HASH_JOIN=Y
db2set DB2COMM=tcpip
db2set DB2_PARALLEL_IO=*
db2set DB2CODEPAGE=819
db2 update dbm cfg using SVCENAME db2inst1
db2 update dbm cfg using INDEXREC ACCESS
db2start
db2 create database kin