DB2共享磁盘无法创建第二个节点的数据库

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