在4台物理机上搭建db2 purescale 测试环境
系统环境:
物理主机资源:CPU:16C MEM:32G
操作系统版本:suse 11 sp4
数据库版本:v10.5fp10_linuxx64_universal_fixpack
db2inst1@db2sr01:~> db2instance -list
ID TYPE STATE HOME_HOST CURRENT_HOST ALERT PARTITION_NUMBER LOGICAL_PORT NETNAME
0 MEMBER STARTED db2sr02 db2sr02 NO 0 0 db2sr02
1 MEMBER STARTED db2sr04 db2sr04 NO 0 0 db2sr04
128 CF PRIMARY db2sr01 db2sr01 NO - 0 db2sr01
129 CF PEER db2sr03 db2sr03 NO - 0 db2sr03
HOSTNAME STATE INSTANCE_STOPPED ALERT
db2sr03 ACTIVE NO NO
db2sr01 ACTIVE NO NO
db2sr04 ACTIVE NO NO
db2sr02 ACTIVE NO NO
db2inst1@db2sr02:~> db2instance -list
ID TYPE STATE HOME_HOST CURRENT_HOST ALERT PARTITION_NUMBER LOGICAL_PORT NETNAME
0 MEMBER STARTED db2sr02 db2sr02 NO 0 0 db2sr02
1 MEMBER STARTED db2sr04 db2sr04 NO 0 0 db2sr04
128 CF PEER db2sr01 db2sr01 NO - 0 db2sr01
129 CF PRIMARY db2sr03 db2sr03 NO - 0 db2sr03
HOSTNAME STATE INSTANCE_STOPPED ALERT
db2sr03 ACTIVE NO NO
db2sr01 ACTIVE NO NO
db2sr04 ACTIVE NO NO
db2sr02 ACTIVE NO NO
db2inst1@db2sr02:~>
db2inst1@db2sr01:~> db2instance -list
ID TYPE STATE HOME_HOST CURRENT_HOST ALERT PARTITION_NUMBER LOGICAL_PORT NETNAME
0 MEMBER STARTED db2sr02 db2sr02 NO 0 0 db2sr02
1 MEMBER STARTED db2sr04 db2sr04 NO 0 0 db2sr04
128 CF PRIMARY db2sr01 db2sr01 NO - 0 db2sr01
129 CF PEER db2sr03 db2sr03 NO - 0 db2sr03
HOSTNAME STATE INSTANCE_STOPPED ALERT
db2sr03 ACTIVE NO NO
db2sr01 ACTIVE NO NO
db2sr04 ACTIVE NO NO
db2sr02 ACTIVE NO NO
db2inst1@db2sr01:~>
db2inst1@db2sr03:~> db2instance -list
ID TYPE STATE HOME_HOST CURRENT_HOST ALERT PARTITION_NUMBER LOGICAL_PORT NETNAME
0 MEMBER STARTED db2sr02 db2sr02 NO 0 0 db2sr02
1 MEMBER STARTED db2sr04 db2sr04 NO 0 0 db2sr04
128 CF ERROR db2sr01 db2sr01 YES - 0 db2sr01
129 CF PEER db2sr03 db2sr03 NO - 0 db2sr03
HOSTNAME STATE INSTANCE_STOPPED ALERT
db2sr03 ACTIVE NO NO
db2sr02 ACTIVE NO NO
db2sr04 ACTIVE NO NO
db2sr01 INACTIVE NO YES
There is currently an alert for a member, CF, or host in the data-sharing instance. For more information on the alert, its impact, and how to clear it, run the following command: 'db2cluster -cm -list -alert'.
db2inst1@db2sr03:~>
db2inst1@db2sr02:~> db2instance -list
ID TYPE STATE HOME_HOST CURRENT_HOST ALERT PARTITION_NUMBER LOGICAL_PORT NETNAME
0 MEMBER STARTED db2sr02 db2sr02 NO 0 0 db2sr02
1 MEMBER STARTED db2sr04 db2sr04 NO 0 0 db2sr04
128 CF PEER db2sr01 db2sr01 NO - 0 db2sr01
129 CF PRIMARY db2sr03 db2sr03 NO - 0 db2sr03
HOSTNAME STATE INSTANCE_STOPPED ALERT
db2sr03 ACTIVE NO NO
db2sr01 ACTIVE NO NO
db2sr04 ACTIVE NO NO
db2sr02 ACTIVE NO NO
1、会不会是GPFS文件系统引起,切换不成功。
/usr/lpp/mmfs/bin/mmchconfig usePersistentReserve=yes (修改参数,报错磁盘不支持)