Re: No future for DB2

"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message news:1122964652.411527.236350_at_g44g2000cwa.googlegroups.com...
> Madison Pruet wrote:
> > Does Oracle snapshot replication
> >
> > 1) replicate all of the trigger activity performed on the original table
> > 2) distinguish between updates on a row and inserts/deletes on the same
row?
> > (If not, then cascade deletes are not properly performed)
> > 3) properly handle cascading updates
>
> If I understand your question correctly, that is not possible
> with ANY replication in any database version.
> Traditionaly, when one replicates a table, one only wants the data
> of that table. What you are saying is that the entire schema
> potentially dependent on that table might also need to be replicated?
>
> If so, I suggest you look at Dataguard: it's the appropriate product
> to achieve it and yes, it does the lot. To try and do that with
> replication is to pay a huge overhead to achieve something that can
> be done a lot more efficiently with different technology.
>

Noons --- IBM Informix Enterprise Replication supports this functionality with about 1/3 the overhead of the original transaction. Received on Tue Aug 02 2005 - 07:24:41 CDT