469,317 Members | 1,915 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,317 developers. It's quick & easy.

Running a HADR script outside of the HADR Wizard

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.
Nov 12 '05 #1
1 2795
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" <bw********@yahoo.com> wrote in message
news:18**************************@posting.google.c om...
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by bwmiller16 | last post: by
4 posts views Thread by bwmiller16 | last post: by
7 posts views Thread by Mark A | last post: by
16 posts views Thread by gumby | last post: by
4 posts views Thread by madzambonis | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.