Categories

A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

DB2 HADR for dummies – Part 3

This is the last post about HADR, I think I covered most of the basics of HADR finishing off with how it switches primary and standby.  What I have gone over is the basics of HADR.  There are many other topics within HADR.  One important thing to remember is to NEVER do unlogged operations (careful with the load command).  Not only will it ‘break’ HADR standby, but it will not tell you — you’ll not find out until you switch over to the standby to find it unusable.  I believe that in version 9.7, we are being allowed access to the standby.  This will allow you to validate the usability of the standby as well as other things like reporting.

This entry is about how to use HADR.  Once again, just the basics.

The command to switch the primary/standby pair is:

from the standby database:
db2 takeover hadr on database sample

simple as that, the standby is now the primary and the old primary is now the standby.

There is also a feature – ACR (automatic client re-route) which can automatically automatically re-route your client to the new primary database when it can not access the current primary.

Leave a Reply

Buy Generic Viagra USA
Where TO Buy Viagra Online
Buy Viagra Where
Cheap Cheap Viagra
Line Viagra
Buy Discount Viagra
Cheapest viagra online Pills
Buy Viagra Sample
Cheap Viagra Online
Cheap Viagra FAST Shipping
Viagra for Sale
Buy Viagra New York
Cheap Websites For Viagra
Viagra FOR Sales Online
Cheapest Viagra Prices
Cheap Viagra Pills