DB2 DPF 测试环境搭建
克服了无数小问题后，终于搭建起来测试环境了
总的教程：
http://www.ibm.com/developerworks/data/library/techarticle/dm-0504mcarthur/index.html
1.Server准备
2.文件系统
3.建立实例
4.rsh
5.测试
环境：
Server:
test64bit00
test64bit01
node:
0 test64bit00 0
1 test64bit00 1
2 test64bit01 0
3 test64bit01 1
User ID:
dpfinst1:x:1004:999::/db2home/dpfinst1:/bin/bash
dpffen1:x:1003:998::/db2home/dpffen1:/bin/bash
dpfdas1:x:1002:997::/home/dpfdas1:/bin/bash
Share home path:
/db2home
1.Server准备
现在vmware装好DB2，建好用户，然后使用clone功能复制多一台
然后更新各自的IP就好
因为DB2安装路径、版本，用户和组的ID都必须一样，所以这样做既省事又准确
--添加用户groupadd -g 999 db2iadm1groupadd -g 998 db2fadm1groupadd -g 997 dasadm1useradd -u 1004 -g db2iadm1 -m -d /db2home/dpfinst1 dpfinst1 -p manager1useradd -u 1003 -g db2fadm1 -m -d /db2home/dpffen1 dpffen1 -p manager1useradd -u 1002 -g dasadm1 -m -d /home/dpfdas1 dpfdas1 -p manager1passwd db2inst1passwd db2fenc1passwd dasusr1--补齐包rpm -ivh rsh-server-0.17-40.el5.x86_64.rpm --相应的服务service portmap startservice nfs startchkconfig rsh on--更新/etc/hosts192.168.221.137 test64bit01192.168.221.136 test64bit00
mkdir /db2home--在/etc/fstab里面添加：/dev/sdc/db2homeext3defaults00--在/etc/exports里面添加：/db2home test64bit00(rw,sync,no_root_squash) test64bit01(rw,sync,no_root_squash)--允许相应的server进行读写--应用更改/usr/sbin/exportfs -a
mkdir /db2home--在/etc/fstab里面添加：test64bit00:/db2home /db2home nfs rw,timeo=300,retrans=5,hard,intr,bg,nolock,suid--刷新最新的挂载点mount -a
[root@test64bit00 db2home]# touch a[root@test64bit01 db2home]# ll a-rw-r--r-- 1 root root 0 Nov 23 16:58 a
--建立一次就好了[root@test64bit00 db2home]# /opt/ibm/db2/V9.5/instance/db2icrt -u dpffen1 dpfinst1DBI1070I Program db2icrt completed successfully.--把db2profile加到bash profile里面[dpfinst1@test64bit01 ~]$ tail -1 .bash_profile/db2home/dpfinst1/sqllib/db2profile--更新相应的连接配置--在/etc/services里面保证两边相同[root@test64bit01 db2home]# grep -i dpf /etc/services DB2_dpfinst1 60020/tcpDB2_dpfinst1_1 60021/tcpDB2_dpfinst1_2 60022/tcpDB2_dpfinst1_END 60023/tcpdb2 update dbm cfg using SVCENAME DB2_dpfinst1db2set DB2COMM=tcpip
[dpfinst1@test64bit00 ~]$ cat sqllib/db2nodes.cfg 0 test64bit00 01 test64bit00 12 test64bit01 03 test64bit01 1
vi /db2home/dpfinst1/.rhoststest64bit00 dpfinst1test64bit01 dpfinst1chmod 600 /db2home/dpfinst1/.rhosts
[dpfinst1@test64bit00 ~]$ db2_all date Wed Nov 23 17:06:19 CST 2011test64bit00: date completed ok Wed Nov 23 17:06:19 CST 2011test64bit00: date completed ok Wed Nov 23 17:06:19 CST 2011test64bit01: date completed ok Wed Nov 23 17:06:19 CST 2011test64bit01: date completed ok
connect to address 192.168.221.137 port 544: Connection refusedTrying krb4 rsh...connect to address 192.168.221.137 port 544: Connection refusedtrying normal rsh (/usr/bin/rsh)test64bit01: Connection refused
cd /usr/kerberos/binmv rsh rsh.bak20110602ln -s /usr/bin/rsh rsh
[root@test64bit01 ~]# dmesg -clockd: server 192.168.221.136 not responding, timed outlockd: server 192.168.221.136 not responding, timed out[dpfinst1@test64bit01 ~]$ db2 list db directorySQL5005C System Error.[dpfinst1@test64bit01 ~]$ db2startSQL1042C An unexpected system error occurred. SQLSTATE=58004
