一、DB2 DPF部署过程
1、DB2版本检查
su -db2inst1
db2licm -l
2、dpf分区特效检查
cat $DB2_HOME/db2nodes.cfg
3、创建分区组
db2 "create database partition group pgmult on dbpartitionnums(0,1,2,3,4,5,6,7,8,9,10,11,12,13,14)"
db2 "create database partition group pgsign on dapertitionnums(15)"
4、db2用户创建
su -db2inst1
db2 connect to ecifdpf
db2 grant dbadm on database to user ecifetl
5、db2数据库创建
db2 "create database ecifdpf on /db2data using codeset UTF-8 territory cn"
6、修改参数
db2 connect to ecifdpf user db2inst1 using db2inst1
db2 "update db cfg for ecifdpf using logprimary 20 immediate"
db2 "update db cfg for ecifdpf using LOGSECOND 60 immediate"
db2 "update db cfg for ecifdpf using LOGFILSIZ 8192 immediate"
7、重启数据库
db2 force application all
db2stop
db2start
查看参数是否生效
db2 get db cfg show detail
8、创建db2 load 日志目录<