Hi Bruce,
The steps to setup HADR manually are:
1) On the Primary
a)Enable log recovery
db2 update db cfg for <dbname> logreatin on
b)Take an offline backup
c) Update HADR parameters in DB CFG
HADR_LOCAL_HOST <hostname of primary>
HADR_LOCAL_SVC <service name for HADR on primary server -
must be greater that 2 than the SVCENAME in the DBM CFG>
HADR_REMOTE_HOS T <hostname of secondary>
HADR_REMOTE_SVC <service name for HADR server must be
greater that 2 than the SVCENAME in the DBM CFG>
HADR_REMOTE_INS T <instance name on secondary>
HADR_TIMEOUT 120
HADR_SYNCMODE NEARSYNC
LOGINDEXBUILD 1
2) On the secondary
b) Restore the backup - without rolling forward
c) Update HADR parameters in DB CFG
HADR_LOCAL_HOST <hostname of secondary>
HADR_LOCAL_SVC <service name for HADR on secondary server -
must be greater that 2 than the SVCENAME in the DBM CFG>
HADR_REMOTE_HOS T <hostname of primary>
HADR_REMOTE_SVC <service name for HADR primary server - must
be greater that 2 than the SVCENAME in the DBM CFG>
HADR_REMOTE_INS T <instance name on primary>
HADR_TIMEOUT 120
HADR_SYNCMODE NEARSYNC
LOGINDEXBUILD 1
3) On the secondary - start HADR
db2 start hadr on db <dbnam> as standby
4) On the promary - start HADR
db2 start hadr on db <dbname> as primary
Now you should be all set to go.
Cheers,
"Bruce M" <bw********@yah oo.com> wrote in message
news:18******** *************** ***@posting.goo gle.com...
Is there a way to run the db2-generated HADR-create script outside of
DB2CC beyond the obvious? My DB2CC generates the HADR script and then
abends because of a java error meaning I can't finish my HADR
creation.
In looking at the script it isn't necessarily obvious which commands
should run on the primary server and which should be run on the
standby server.
