| re: Running a HADR script outside of the HADR Wizard
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_HOST <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_INST <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_HOST <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_INST <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" <bwmiller16@yahoo.com> wrote in message
news:184e6bd6.0409161226.3b3c4572@posting.google.c om...[color=blue]
> 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.[/color]
| 
