使用 db2haicu 工具为 DB2 配置高可用性

# preprpnode cmaix25 cmaix26

cd ./db2/aix/tsamp 
 root@cmaix25 # ./installSAM 
 prereqSAM: All prerequisites for the ITSAMP installation are met on operating system AIX 
 5300-09 
 installSAM: Packages will be installed from directory ./AIX 
 installSAM: The following package is not installed yet and needs to be 
 installed ./AIX/sam.core 

 installSAM: A general License Agreement and License Information specifically for System 
 Automation will be shown. Scroll down using the Enter key (line by line) or Space bar 
 (page by page). At the end you will be asked to accept the terms to be allowed to 
 install the product. Select Enter to continue 
 ... ... 
 installSAM: To accept all terms of the preceding License Agreement and License 
 Information type 'y', anything else to decline
 
 

root@cmaix25 # su - db2inst1 
 $ id 
 uid=203(db2inst1) gid=102(db2iadm1) groups=1(staff),101(dasadm1),103(db2fadm1)

root@cmaix25 # chvg -a n DB2HOME

root@cmaix25 # lspv 
 hdisk0 000925926d77bb8e rootvg active 
 hdisk2 000a5d72aa712308 DB2HOME active

root@cmaix25 # ls -al /dev/DB2HOME 
 crw-rw---- 1 root system 45, 0 Jun 04 04:31 /dev/DB2HOME

root@cmaix26 # importvg -y DB2HOME -V 45 hdisk2

db2 update alternate server for database <DB Name> using <Virtual IP> port <PORT>

 $db2start06/10/2009 03:17:44 0 0 SQL1063N DB2START processing was successful. 
 
 SQL1063N DB2START processing was successful. 
 $ 
 $db2haicuWelcome to the DB2 High Availability Instance Configuration Utility (db2haicu). 

 You can find detailed diagnostic information in the DB2 server diagnostic log file 
called db2diag.log.  Also, you can use the utility called db2pd to query the status 
of the cluster domains you create. 

 For more information about configuring your clustered environment using db2haicu, 
 see the topic called 'DB2 High Availability Instance Configuration Utility (db2haicu)' 
in the DB2 Information Center. 

 db2haicu determined the current DB2 database manager instance is db2inst1. 
 The cluster configuration that follows will apply to this instance. 

 db2haicu is collecting information on your current setup. 
 This step may take some time as db2haicu will need to activate all databases 
for the instance to discover all paths ... 
 When you use db2haicu to configure your clustered environment, you create 
cluster domains.  For more information, see the topic 'Creating a cluster domain
 with db2haicu' in the DB2 Information Center. 
 db2haicu is searching the current machine for an existing active cluster domain ... 
 db2haicu did not find a cluster domain on this machine. 
 db2haicu will now query the system for information about cluster nodes to 
create a new cluster domain ... 

 db2haicu did not find a cluster domain on this machine. 
 To continue configuring your clustered environment for high availability, 
 you must create a cluster domain; otherwise, db2haicu will exit.
 
 

Create a domain and continue? [1] 
 1. Yes 
 2. No 
 1 
 Create a unique name for the new domain: 
 cmaix2526 
 Nodes must now be added to the new domain. 
 How many cluster nodes will the domain cmaix2526 contain? 
 2 
 Enter the host name of a machine to add to the domain: 
 cmaix25 
 Enter the host name of a machine to add to the domain: 
 cmaix26 
 db2haicu can now create a new domain containing the 2 machines that you specified. 
 If you choose not to create a domain now, db2haicu will exit. 

 Create the domain now? [1] 
 1. Yes 
 2. No 
 1 
 Creating domain cmaix2526 in the cluster ... 
 Creating domain cmaix2526 in the cluster was successful.

You can now configure a quorum device for the domain. For more information, 
see the topic "Quorum devices" in the DB2 Information Center. 
If you do not configure a quorum device for the domain, 
then a human operator will have to manually intervene if 
subsets of machines in the cluster lose connectivity. 

 Configure a quorum device for the domain called cmaix2526? [1] 
 1. Yes 
 2. No 
 1 
 The following is a list of supported quorum device types: 1. Network Quorum 
 Enter the number corresponding to the quorum device type to be used: [1] 
 1 
 Specify the network address of the quorum device: 
 9.123.112.1 
 Configuring quorum device for domain cmaix2526 ... 
 Configuring quorum device for domain cmaix2526 was successful.

The cluster manager found 2 network interface cards on the machines in the domain. 
You can use db2haicu to create networks for these network interface cards. 
For more information, see the topic 'Creating networks with db2haicu' 
in the DB2 Information Center. 

 Create networks for these network interface cards? [1] 
 1. Yes 
 2. No 
 1 
 Enter the name of the network for the network interface card: en0 
on cluster node: cmaix25.cn.ibm.com 
 1. Create a new public network for this network interface card. 
 2. Create a new private network for this network interface card. 
 Enter selection: 
 1 
 Are you sure you want to add the network interface card en0 on cluster 
 node cmaix25.cn.ibm.com to the network db2_public_network_0? [1] 
 1. Yes 
 2. No 
 1 
 Adding network interface card en0 on cluster node cmaix25.cn.ibm.com to the 
network db2_public_network_0 ... 
 Adding network interface card en0 on cluster node cmaix25.cn.ibm.com to the 
network db2_public_network_0 was successful. 
 Enter the name of the network for the network interface card: en0 on cluster 
node: cmaix26.cn.ibm.com 
 1. db2_public_network_0 
 2. Create a new public network for this network interface card. 
 3. Create a new private network for this network interface card. 
 Enter selection: 
 1 
 Are you sure you want to add the network interface card en0 on cluster node 
cmaix26.cn.ibm.com to the network db2_public_network_0? [1] 
 1. Yes 
 2. No 
 1 
 Adding network interface card en0 on cluster node cmaix26.cn.ibm.com to the 
network db2_public_network_0 ... 
 Adding network interface card en0 on cluster node cmaix26.cn.ibm.com to the 
network db2_public_network_0 was successful.
 
 

Retrieving high availability configuration parameter for instance db2inst1 ... 
 The cluster manager name configuration parameter 
(high availability configuration parameter) 
 is not set. For more information, see the topic "cluster_mgr - Cluster manager 
 name configuration parameter" in the DB2 Information Center. 
 Do you want to set the high availability configuration parameter? 
 The following are valid settings for the high availability configuration 
parameter: 1.TSA 2.Vendor 
 Enter a value for the high availability configuration parameter: [1] 
 1 
 Setting a high availability configuration parameter for instance db2inst1 to TSA. 
 Now you need to configure the failover policy for the instance db2inst1. 
 The failover policy determines the machines on which the cluster manager will 
 restart the database manager if the database manager is brought offline unexpectedly. 

 The following are the available failover policies: 1. Local Restart -- during failover, 
 the database manager will restart in place on the local machine 2. 
 Round Robin -- during failover, the database manager will restart on any machine 
 in the cluster domain 3. Active/Passive -- during failover, the database manager 
 will restart on a specific machine 4. M+N -- during failover, the database 
 partitions on one machine will failover to any other machine in the cluster 
 domain (used with DPF instances) 5. Custom -- during failover, the database 
 manager will restart on a machine from a user-specified list 
 Enter your selection: 
 3

You can identify mount points that are noncritical for failover. 
For more information, see the topic 'Identifying mount points that are noncritical 
for failover' in the DB2 Information Center. 
Are there any mount points that you want to designate as noncritical? [2] 
 1. Yes 
 2. No 
 2 
 Active/Passive failover policy was chosen. 
 You need to specify the host names of an active/passive pair. 
 Enter the host name for the active cluster node: 
 cmaix25 
 Enter the host name for the passive cluster node: 
 cmaix26 
 Adding DB2 database partition 0 to the cluster ... 
 Adding DB2 database partition 0 to the cluster was successful.

Do you want to configure a virtual IP address for the DB2 partition: 0? [2] 
 1. Yes 
 2. No 
 1 
 Enter the virtual IP address: 
 9.123.112.254 
 Enter the subnet mask for the virtual IP address 9.123.112.254: [255.255.255.0] 
 255.255.255.0 
 Select the network for the virtual IP 9.123.112.254: 
 1. db2_public_network_0 
 Enter selection: 
 1 
 Adding virtual IP address 9.123.112.254 to the domain ... 
 Adding virtual IP address 9.123.112.254 to the domain was successful. 
 All cluster configurations have been completed successfully. db2haicu exiting ...