DB2共享磁盘无法创建第二个节点的数据库
在节点二创建数据库：EDUDATA失败。
提示：
The database alias "EDUDATA" already exists in either the local
database directory or system database directory.
各位大侠，该如何是好？请指教，感谢。
6同行回答
1、install xlc.rte.aix50.jul2007.ptf.tar
smitty update_all
mount /home/db2inst1
mount /home/db2fenc1
注：/home/db2inst1,/home/db2fenc1在datavg上。
2、创建DB2用户和组
mkgroup id=300 db2iadm1
mkgroup id=301 db2fgrp1
mkgroup id=302 dasadm1
mkuser id=300 pgrp=db2iadm1 groups=db2iadm1home=/db2home/db2inst1
core=-1 data=491519 stack=32767 rss=-1 fsize=-1 db2inst1
mkuser id=301 pgrp=db2fgrp1 groups=db2fgrp1home=/db2home/db2fenc1
db2fenc1
mkuser id=302 pgrp=dasadm1 groups=dasadm1home=/home/db2das
db2das
passwd db2inst1 (password=root)
chown -R db2inst1:db2iadm1 /home/db2inst1
chown -R db2fenc1:db2fgrp1 /home/db2fgrp1
chown -Rdb2das:dasadm1 /home/db2das
3、安装DB2产品
mount /cdrom/dev/cd0
cd /cdrom
./db2_install -b$DB2DIR -p ESE –n
注：$DB2DIR=/usr/opt/IBM/db2/V9.1
4、创建实例
$DB2DIR/instance/dascrt-u db2das
$DB2DIR/instance/db2icrt-s ese -u db2fenc1 db2inst1
su - db2inst1
db2 update dbmcfg using SVCENAME DB2_db2inst1
db2licm -a../db2ese_c.lic(license文件在另外一张盘上)
5、创建sample数据库
su - db2inst1
cd sqllib/bin
./db2sampl
db2 connect to sample
db2 catalog tcpip node node1 remote10.9.162.22 server 60000
db2 catalog db sample as sample1 at nodenode1
db2 connect to sample1 user db2inst1 usingroot
6、配置HA
在另外一台机器上重复1-6，但是不mount/home/db2inst1,/home/db2fenc1
cd /home/db2inst1
rm -r *
mount /home/db2inst1
cd /home/db2fen1
rm -r *
mount /home/db2fenc1
chown -R db2inst1:db2iadm1 /home/db2inst1
chown -R db2fenc1:db2fgrp1 /home/db2fgrp1
su - db2inst1
cp db2nodes.cfg db2nodes.cfg.A
cp db2nodes.cfg db2nodes.cfg.B
修改db2nodes.cfg.B中主机名为当前主机名。
将hastart.sh hastop.sh放到HA相应的位置，用来启动停止数据库实例。
附录1：hastart.sh
banner hastart
#!/usr/bin/ksh
HOST=`/usr/bin/hostname`
if [ "$HOST" ="MC_ETC_DB_A" ] ; then
su- db2inst1 -c "cp /home/db2inst1/sqllib/db2nodes.cfg.A/home/db2inst1/sqllib/db2nodes.cfg"
else
su - db2inst1 -c "cp/home/db2inst1/sqllib/db2nodes.cfg.B /home/db2inst1/sqllib/db2nodes.cfg"
fi
su- db2inst1 -c /usr/opt/IBM/db2/V9.1/bin/ipclean
su- db2inst1 -c db2start
exit 0
附录2：hastop.sh
banner hastop
#!/usr/bin/ksh
HOST=`/usr/bin/hostname`
if ["$HOST" = "MC_ETC_DB_A" ] ; then
su - db2inst1 -c "cp/home/db2inst1/sqllib/db2nodes.cfg.A
/home/db2inst1/sqllib/db2nodes.cfg"
else
su - db2inst1-c "cp /home/db2inst1/sqllib/db2nodes.cfg.B/home/db2inst1/sqllib/db2nodes.cfg"
fi
echo "db2 force applications all"
su - db2inst1 -c "db2 force applicationsall"
sleep 10
echo "db2 stoping"
su - db2inst1 -c db2stop
RC=$?
if [ "$RC" -eq 0 ] ; then
echo "DB2 Stopped"
else
echo "Forcing DB2 shutdown"
su - db2inst1 -c "db2stop force"
fi
exit 0