Modify db2ha_sample_HADR.xml to reinstall HADR for instance with 6 databases.

[kenZ]

I am trying to modify the same xml script that comes with DB2 for configuring our clustered environment for the current database manager instance but I cannot determine the syntax for having 6 databases for a single instance. All examples are specific to a single database. Each of our 6 databases has its own HADR ip, and there is only 2 servers in our cluster

Can someone shed some light on how to code this for me.


Thank you,

[pramodds]

Hi,

I would suggest to use interactive tool - db2haicu
Just type "db2haicu", you will get lot of interactive options and in the final phase of this interactive configuration it will ask for vaildate and automate databases and that time you can give each & every db name separately. I think this will also work if you have already done setup for one DB with XML cfg and you want to add another 5 Databases, then just type db2haicu it will prompt with options where you can select for adding other databases.

regarding XML file, can you try to repeat the below entires like this - DB1, DB2 and so on. It should also work.

<HADRDBSet>
<HADRDB databaseName="D B1" localInstance=" db2inst1"
remoteInstance= "db2inst1" localHost="hadr 01" remoteHost="had r02" />
<VirtualIPAddre ss baseAddress="9. 26.124.22" subnetMask="255 .255.255.0"
networkName="db 2_public_networ k_0"/>
</HADRDBSet>
<HADRDBSet>
<HADRDB databaseName="D B2" localInstance=" db2inst1"
remoteInstance= "db2inst1" localHost="hadr 01" remoteHost="had r02" />
<VirtualIPAddre ss baseAddress="9. 26.124.22" subnetMask="255 .255.255.0"
networkName="db 2_public_networ k_0"/>
</HADRDBSet>