RayRay wrote:
> I was hoping I might be able to get an answer regarding DB2 and HADR.
> Let me preface this by saying that I know very little about networking
> and I'm not familiar with the HADR product or clustering. But, I've
> been asked to research a couple issues for a client.
>
> They are thinking about implementing HADR. They have DB2 production
> databases running on more than one box.
>
> Does a liscense for HADR need to be purchased for each production box
> running DB2, or does the HADR software come standard as long as you are
> running the Enterprise Edition of DB2 on each box in question?
>
> What would be a recommended architecture for a company that currently
> has multiple databases on a couple of production boxes (I know there
> are a lot of variables that come into play, but I'm trying to get a
> simplistic picture)? Cluster the production boxes together and cluster
> the backup (or standby) boxes together? I assume DB2 and HADR have to
> be available on each box (production or standby) in question.
>
> Please don't get too technical if you respond. Any clarification would
> be greatly appreciated.
I can't comment on the licensing. W.r.t. where to run what my
recommendation is to have distribute the primaries across all the
available servers. That way no server is idle and you get the best use
of your resources because every fail over server also acts as primary
for another database.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/