CentOS6.2安装DB2 V10.1 Express-C

创建用户

/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