--创建物理卷
pvcreate /dev/sdb
--创建卷组
vgcreate -s 64M vg_db2 /dev/sdb
--创建逻辑卷
lvcreate -L 5G -n lv_db2home vg_db2
lvcreate -L 5G -n lv_db2data vg_db2
lvcreate -L 2G -n lv_db2path vg_db2
lvcreate -L 2G -n lv_db2plog vg_db2
lvcreate -L 2G -n lv_db2mlog vg_db2
lvcreate -L 5G -n lv_db2archive vg_db2
--格式化成ext3
mkfs.ext3 -F /dev/mapper/vg_db2-lv_db2home
mkfs.ext3 -F /dev/mapper/vg_db2-lv_db2archive
mkfs.ext3 -F /dev/mapper/vg_db2-lv_db2data
mkfs.ext3 -F /dev/mapper/vg_db2-lv_db2mlog
mkfs.ext3 -F /dev/mapper/vg_db2-lv_db2path
mkfs.ext3 -F /dev/mapper/vg_db2-lv_db2plog
--查看文件系统类型
dpf01:/dev # ls -l /dev/mapper/vg_db2*
lrwxrwxrwx 1 root root 7 Jan 22 07:32 /dev/mapper/vg_db2-lv_db2archive -> ../dm-9
lrwxrwxrwx 1 root root 7 Jan 22 07:32 /dev/mapper/vg_db2-lv_db2data -> ../dm-5
lrwxrwxrwx 1 root root 7 Jan 22 07:32 /dev/mapper/vg_db2-lv_db2home -> ../dm-4
lrwxrwxrwx 1 root root 7 Jan 22 07:32 /dev/mapper/vg_db2-lv_db2mlog -> ../dm-8
lrwxrwxrwx 1 root root 7 Jan 22 07:32 /dev/mapper/vg_db2-lv_db2path -> ../dm-6
lrwxrwxrwx 1 root root 7 Jan 22 07:32 /dev/mapper/vg_db2-lv_db2plog -> ../dm-7
dpf01:/dev # file -s /dev/dm-5
/dev/dm-5: Linux rev 1.0 ext3 filesystem data (needs journal recovery) (large files)
--创建挂载点
mkdir -p /db2home/db2inst1
mkdir -p /db2home/db2fenc1
mkdir /db2data
mkdir /db2path
mkdir /db2plog
mkdir /db2mlog
mkdir /db2archive
mkdir -p /db2home/db2inst1
mkdir -p /db2home/db2fenc1
mkdir /db2data
mkdir /db2path
mkdir /db2plog
mkdir /db2mlog
mkdir /db2archive
--用户和组
groupadd -g 998 db2iadm1
groupadd -g 999 db2fadm1
useradd -u 1001 -g db2iadm1 -m -d /db2home/db2inst1 db2inst1
useradd -u 1002 -g db2fadm1 -m -d /db2home/db2fenc1 db2fenc1
echo "db2inst1:db2" | chpasswd
echo "db2fenc1:db2" | chpasswd
chown -R db2inst1:db2iadm1 /db2path
chown -R db2inst1:db2iadm1 /db2plog
chown -R db2inst1:db2iadm1 /db2mlog
chown -R db2inst1:db2iadm1 /db2archive
chown -R db2inst1:db2iadm1 /db2home
--开机自动挂载
cat >> /etc/fstab < /dev/mapper/vg_db2-lv_db2archive /db2archive ext3 defaults 1 2
/dev/mapper/vg_db2-lv_db2data /db2data ext3 defaults 1 2
/dev/mapper/vg_db2-lv_db2mlog /db2mlog ext3 defaults 1 2
/dev/mapper/vg_db2-lv_db2path /db2path ext3 defaults 1 2
/dev/mapper/vg_db2-lv_db2plog /db2plog ext3 defaults 1 2
/dev/mapper/vg_db2-lv_db2home /db2home ext3 defaults 1 2
EOF
rpm -ivh nfs-kernel-server-1.2.3-18.29.1.x86_64
chkconfig nfsserver on
vi /etc/exports
/db2home *(rw,sync,no_root_squash)
service nfsserver restart
/usr/sbin/exportfs -a
showmount -e dpf01
--rsh
1) 安装
rpm -ivh rsh-server-0.17-706.18.1.x86_64.rpm
2)在两个节点分别修改 /etc/xinetd.d/rsh文件 /etc/xinetd.d/rlogin文件、/etc/xinetd.d/rexec文件:
将disable = yes
修改为disable = no
3)添加信任主机 vi /db2home/db2inst1/.rhosts
192.168.2.71 db2inst1
192.168.2.72 db2inst1
4)在两个节点分别修改 /etc/securetty 文件添加 rsh rlogin rexec信息:
rsh
rlogin
rexec
5)在两个节点分别修改 /etc/pam.d/rsh文件 /etc/pam.d/rlogin文件 /etc/pam.d/rexec文件:
将auth required pam_securetty.so
修改为 #auth required pam_securetty.so
6) 修改权限
chmod 600 .rhosts
7)重启服务
service xinetd restart
--在编目分区节点上,创建实例
cd /opt/ibm/db2/V10.1/instance
./db2icrt -s ese -a server -u db2fenc1 db2inst1
--修改各个分区节点/etc/services文件 4个端口,4个分区
DB2_db2inst1 60000/tcp
DB2_db2inst1_1 60001/tcp
DB2_db2inst1_2 60002/tcp
DB2_db2inst1_END 60003/tcp
--修改分区节点文件
[db2inst1@btedbzsc /db2home/db2inst1/sqllib]>cat db2nodes.cfg
0 dpf01 0
1 dpf01 1
2 dpf02 0
3 dpf02 1
--验证分区
db2_all date
--配置TCP/IP通讯协议
db2set DB2COMM=tcpip
db2 update dbm cfg using svcename 50000
--创建数据库,/db2data 自动存储路径,/db2path 数据库路径
db2 "create db dwdb on /db2data dbpath on /db2path using codeset GBK TERRITORY CN "
--设置主日志路径
db2 "update db cfg for dwdb using NEWLOGPATH /db2plog"
--设置镜像日志
db2 "update db cfg for dwdb using MIRRORLOGPATH /db2mlog"
--设置归档路径
db2 "update db cfg for dwdb using LOGARCHMETH1 disk:/db2archive"
--创建分区组,PDPG 数据分区组,SDPG 单分区组
db2 "create database partition group PDPG on dbpartitionnums (0 to 3)"
db2 "create database partition group SDPG on dbpartitionnums (0) "
--创建缓冲池,100MB 缓冲池,其中30MB为块区域
db2 "create bufferpool BP_16K all dbpartitionnums size 9000 pagesize 16k
numblockpages 3000 blocksize 16"
--创建表空间,所有分区
db2 "create tablespace tbs_big in database partition group PDPG pagesize 16k bufferpool bp_16k
overhead 4.0 transferrate 0.04
"
--创建表空间,单分区
db2 "create tablespace tbs_small in database partition group SDPG pagesize 16k bufferpool bp_16k
overhead 4.0 transferrate 0.04
"
overhead 默认7.5毫秒,磁盘驱动器从接到指令到找到数据所花费的时间。
transferrate 默认 0.06毫秒,从硬盘读一页到内存花费的时间。
--db2 activate db dwdb
SQL0863W A successful connection was made, but only single byte characters
should be used. SQLSTATE=01539
--SQL0332N 代码页问题
[db2inst1@dpf02 db2inst1]$ db2 connect to dwdb
SQL0332N Character conversion from the source code page "1386" to the target
code page "819" is not supported. SQLSTATE=57017
db2set DB2CODEPAGE=1386
设置后重新用实例用户登录。
--备份所有分区节点
db2 "backup db dwdb on all dbpartitionnums online to /db2archive/backup"
db2 "drop table t1"
db2 "create table t1 (id int , c2 varchar(100)) in tbs_big"
db2 "
begin
declare i int default 0;
while (i<90000) do
insert into t1 values(i, 'aaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbbbbbccccccccccccccccc'||char(i) );
set i=i+1;
end while;
end
"
--查看各分区的记录数
db2inst1@dpf01:~> db2 "select dbpartitionnum(id) as "Partition_Num" ,count(id) as "Count" from t1 group by dbpartitionnum(id)"
PARTITION_NUM COUNT
------------- -----------
0 22574
1 22235
3 22449
2 22742
4 record(s) selected.
7)重启服务
service xinetd restart
--------------------------------------------------------------------------------------------------
--在编目分区节点上,创建实例
cd /opt/ibm/db2/V10.1/instance
./db2icrt -s ese -a server -u db2fenc1 db2inst1
--修改各个分区节点/etc/services文件 4个端口,4个分区
DB2_db2inst1 60000/tcp
DB2_db2inst1_1 60001/tcp
DB2_db2inst1_2 60002/tcp
DB2_db2inst1_END 60003/tcp
--修改分区节点文件
[db2inst1@btedbzsc /db2home/db2inst1/sqllib]>cat db2nodes.cfg
0 dpf01 0
1 dpf01 1
2 dpf02 0
3 dpf02 1
--验证分区
db2_all date
--配置TCP/IP通讯协议
db2set DB2COMM=tcpip
db2 update dbm cfg using svcename 50000
db2stop force
db2start
db2start
--创建数据库,/db2data 自动存储路径,/db2path 数据库路径
db2 "create db dwdb on /db2data dbpath on /db2path using codeset GBK TERRITORY CN "
--设置主日志路径
db2 "update db cfg for dwdb using NEWLOGPATH /db2plog"
--设置镜像日志
db2 "update db cfg for dwdb using MIRRORLOGPATH /db2mlog"
--设置归档路径
db2 "update db cfg for dwdb using LOGARCHMETH1 disk:/db2archive"
--创建分区组,PDPG 数据分区组,SDPG 单分区组
db2 "create database partition group PDPG on dbpartitionnums (0 to 3)"
db2 "create database partition group SDPG on dbpartitionnums (0) "
--创建缓冲池,100MB 缓冲池,其中30MB为块区域
db2 "create bufferpool BP_16K all dbpartitionnums size 9000 pagesize 16k
numblockpages 3000 blocksize 16"
--创建表空间,所有分区
db2 "create tablespace tbs_big in database partition group PDPG pagesize 16k bufferpool bp_16k
overhead 4.0 transferrate 0.04
"
--创建表空间,单分区
db2 "create tablespace tbs_small in database partition group SDPG pagesize 16k bufferpool bp_16k
overhead 4.0 transferrate 0.04
"
overhead 默认7.5毫秒,磁盘驱动器从接到指令到找到数据所花费的时间。
transferrate 默认 0.06毫秒,从硬盘读一页到内存花费的时间。
--db2 activate db dwdb
SQL0863W A successful connection was made, but only single byte characters
should be used. SQLSTATE=01539
--SQL0332N 代码页问题
[db2inst1@dpf02 db2inst1]$ db2 connect to dwdb
SQL0332N Character conversion from the source code page "1386" to the target
code page "819" is not supported. SQLSTATE=57017
db2set DB2CODEPAGE=1386
设置后重新用实例用户登录。
--备份所有分区节点
db2 "backup db dwdb on all dbpartitionnums online to /db2archive/backup"
db2 "drop table t1"
db2 "create table t1 (id int , c2 varchar(100)) in tbs_big"
db2 "
begin
declare i int default 0;
while (i<90000) do
insert into t1 values(i, 'aaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbbbbbccccccccccccccccc'||char(i) );
set i=i+1;
end while;
end
"
--查看各分区的记录数
db2inst1@dpf01:~> db2 "select dbpartitionnum(id) as "Partition_Num" ,count(id) as "Count" from t1 group by dbpartitionnum(id)"
PARTITION_NUM COUNT
------------- -----------
0 22574
1 22235
3 22449
2 22742
4 record(s) selected.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22661144/viewspace-1412562/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22661144/viewspace-1412562/