Setting up HADR by using the command line
Setting up HADR is straightforward. You can use a variety of methods to set up HADR, using the command line or Control Center, and IBM Optim Database Administrator HADR setup wizards. In the following recipe, we will set up HADR using the command line.
Getting ready
In this recipe, nodedb21
will be used for the initial primary database, and nodedb22
for the initial standby database. We use the term initially, because in the following recipes, we will initiate takeover and takeover by force operations, and the databases will exchange and change their roles. All operations will be conducted on the non-partitioned NAV
database, under instance db2inst1
on nodedb21
, and db2inst1
on nodedb22
.
How to do it...
To set up a HADR configuration, we will use the following steps:
Install IBM DB2 9.7 ESE in location
/opt/ibm/db2/ V9.7_01, on nodedb22
Creating additional directories for log archiving, backup, and mirror log locations, on both nodes
Setting proper permissions...