470,831 Members | 1,689 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Share your developer knowledge by writing an article on Bytes.

Db2 9.5 HADR failures on Linux Susie 10 on multi servers\VM ware

DB2 Warlord
After countless time I was unabl to find the answer to my HADR questions and getting HADR to work in 9.5 via the Control Center. Please see my fix that seem strange but works.

My error was as follows. When setting up HADR via the CCenter at the last step in a full setup called "START HADR" it would fail with reason 7.

Now trying to solve the port issue that is listed gets you no where. In fact on my db2diag.log it listed a comm error. This is not even the issue! stupid db2. IBM support was NULL!

Let me give you a run down.
1 make a backup of your database.
2 take your back or clone and move it to your STANDBY server via SCP-"Make sure your database has no HADR settings at this point, but that your Linux Service file on both the Primary and Standby does have a port entry that you know for the wizard, where it asks for Alias and Port "
3. Start CCenter
4. Run through the entire Setup HADR wizard.
5. Have a second copy of your Standby server open in say a FTP Putty Sessson. With your self logged into the instance as instance owner type "db2 activate database" right before it says "Start HADR" on your primary server tryig to connect to your STANDBY server via the CC wizard.
My biggest question following everything out there was this? How do you set your HADR settings on a database without making your clone or backup database Active. Of course if you make your database active, such as after a restore by rolling forward your logs, Stupid HADR says you cant activate HADR on an Active database. So just deactivate you may be thinking. Well I was also, but in my case this did nothing but waste time. A deactive database had no better luck than before.
Sep 29 '09 #1
0 3516

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by bwmiller16 | last post: by
2 posts views Thread by bwmiller16 | last post: by
1 post views Thread by Mark A | last post: by
7 posts views Thread by Marc | last post: by
16 posts views Thread by gumby | last post: by
2 posts views Thread by paul | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.