Re: HDR and ER

Hi :> I have the same issue here. Can anybody help? Regards, Dirk Magiera wrote: > > Hi all :) > > I wonder if someone can give me some helpful hints > about HDR and ER. > > Situation: Seven IDS 7.23 UC13 ( on: SCO Open Server 3.2v5.0.5) > exchanging master table data via ER (update anywhere). > > We would now like to "mirror" each of the database > machines (physically into new machines) > in order to 1) gain some (hardware) redundancy and > 2) let some reporting tasks run against the mirror > machines instead of the primary database machines. > For the uses above the mirroring must be > just in time. > > Sadly enough we came to know that HDR would be the > option of choice but ER doesnt work together with > HDR. > > We could now run the whole thing via ER replicating > all the hundreds of tables but this would mean > an enormous amount of administrative work involved > (i.e. making all tables ER-able, managing the whole > process, doing the same thing again whenever a new > table is created...). > > My question is if there isnt an easier approach. > We also played around with completed logfiles but > ontape always forces a complete physical restore > before we can do a logical restore. > > Any ideas? > > Thanks in advance > Heinz > >