Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Manual Scripts to Perform HADR Failover

Manual Scripts to Perform HADR Failover

Manual Scripts to Perform HADR Failover

I need to setup automating failover for live HADR clusters.
Environment: Windows 2008 R2 64 bit, DB2 v9.7 ESE FP 3a
It seems I cannot use a solution like Tivoli System Automation for Multiplatforms. (license issue)
I might need to implement manual scripts for doing this task asap ...
I searched through the internet and I did not find anything suitable ...
Is this possible to create .sql scripts or can you do this using Task Center by creating different tasks that perform some checks?
The big problem is what to check in order to decide when to perform the failover?
1. To check if you can connect to DB's
2. To connect and also to list applications to see if there are any applications running also?
(it is possible that applications run but you cannot connect ... different scenarios ... )
Also I am concerned in setting up for HADR: SYNC, NEARSYNC, ASYNC and HADR_PEER_WINDOW value...
(these are servers sitting in the same rack - recommended SYNC, two Ethernet connections)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close