Re: No future for DB2

"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message news:42f1ede1$0$11939$5a62ac22_at_per-qv1-newsreader-01.iinet.net.au...
> Madison Pruet apparently said,on my timestamp of 4/08/2005 9:21 AM:
> >
> > Fair enough --- on the IDS informix server, to do this with say 5
instances
> > by issueing the two commands
> >
> > cdr define template noons --database=noons --master=node1 --all
> > cdr realize template noons --syncdatasource=node1 node2 node3 node4
node5
> >
> > This would set up an update anywhere of everything in the noons database
> > using the five servers.
>
> Thank you. Like I suspected, you have to relicate the entire database.
> It is much more efficient to do that in Oracle via dataguard. Like
> I said nearly 24 hours ago. Of course, you can also template
> the entire database and replicate the lot. Anything is possible,
> provided you have sufficient resources.

No Noons. You asked how I would do it, not how it had to be done.

Since the IBM Informix Enterprise Replication uses less than 10% of the total resources, it is simply easier to replicate the whole DB. And since disks are so cheap now, I would have difficulty not justifying having a multi-node grid like arrangement so that the applications could be active on any of the replicated nodes.

>
> --
> Nuno Souto
> in sunny Sydney, Australia
> wizofoz2k_at_yahoo.com.au.nospam
Received on Thu Aug 04 2005 - 09:48:03 CDT