Re: No future for DB2
A licensing/feature argument (part of a DB2 vs Oracle vs Informix flame war) over whether replication costs extra. The specific question raised was whether Oracle replication is limited to Enterprise Edition. Posters clarified it isn't: basic/snapshot (materialized view) replication ships with Standard Edition in 9i and 10g, while Advanced/multi-master replication is EE-only, with quotes from Oracle's 9iR2 New Features and 10g Licensing manuals. Also noted that DB2 replication to Oracle/SQL Server requires IBM Information Integrator, and that snapshot copies replicate data but not trigger/cascade logic. No single technical problem was fixed; the thread ends with the licensing facts corrected.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I didn't know that Oracle replication was available on the standard edition. I thought that it was only available on the enterprise edition. Am I mistaken? "Bob Jones" <email@me.not> wrote in message news:YYfHe.192$fJ1.130@newssvr13.news.prodigy.com... > > That's not the point. One of your complaints about DB2 was that > > Replication costs $. It doesn't ... only on z/OS and i-series. So does > > Oracle apparently. > > > > Larry E. > > > > Bob Jones wrote: > >> Now, is z/OS Oracle's product or is it as open as UNIX, or even Windows? > >> Besides z/OS is not even a primary platform for Oracle, but it is for > >> DB2. > >> > >> > >>>And let me guess ... to replicate from Oracle on z/OS to a database on > >>>LUW is free? > >>> > >>>Larry E. > >>> > >>>Bob Jones wrote: > >>> > >>>>>>No, partitioning is not included in DB2 Workgroup Edition. You can't > >>>>>>even do simple replications in DB2 without purchasing a separate > >>>>>>product. > >>>>>> > >>>>> > >>>>>We have been discussing here primarily DB2 for Linux/UNIX/Windows > >>>>>right? This is not true. Replication is included free-of-charge with > >>>>>DB2 WE and with DB2 ESE. > >>>>> > >>>> > >>>> > >>>>I am talking about replicating data from DB2 on z to DB2 on LUW. > >> > >> > > So DB2 on z/OS or iSeries is not DB2? I don't know where you read Oracle > charges simple replication as a separate product on any platform. The fact > that IBM is charging customers for simple replication with DB2 running on > its own platforms is exactly my complain. > >
Replicaton to/from Oracle has nothing do with Enterprise and/or standard edition - to replicate to Oracle or SQL Server, you need IBM Information Integator.
Madison Pruet wrote: > I didn't know that Oracle replication was available on the standard edition. > I thought that it was only available on the enterprise edition. Am I > mistaken? 1. Please don't top post. 2. You are correct. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)
bka wrote: > Replicaton to/from Oracle has nothing do with Enterprise and/or > standard edition - to replicate to Oracle or SQL Server, you need IBM > Information Integator. I understand that runs really well on the Mac OSX/Darwin platform. ;-) -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)
DA Morgan wrote: > Madison Pruet wrote: > > I didn't know that Oracle replication was available on the standard edition. > > I thought that it was only available on the enterprise edition. Am I > > mistaken? > > 1. Please don't top post. > 2. You are correct. He's correct in that he's mistaken. Snapshot replication (basic replication) *is* available in Standard Edition, 9i. Advanced replication (master2master) is only in EE. 10g might have changed that, but that will be another reason for people not to upgrade...
basic replication still available in 10g SE but.. Flashback only in 10g EE I think that MySQL will come even more popular with non mission critical systems. "Noons" <wizofoz2k@yahoo.com.au> wrote in message news:1122880229.362562.321330@o13g2000cwo.googlegroups.com... > >> 2. You are correct. > > He's correct in that he's mistaken. Snapshot replication > (basic replication) *is* available in Standard Edition, 9i. > Advanced replication (master2master) is only in EE. > 10g might have changed that, but that will be another > reason for people not to upgrade... >
"Noons" <wizofoz2k@yahoo.com.au> wrote in message news:1122880229.362562.321330@o13g2000cwo.googlegroups.com... > > DA Morgan wrote: > > Madison Pruet wrote: > > > I didn't know that Oracle replication was available on the standard edition. > > > I thought that it was only available on the enterprise edition. Am I > > > mistaken? > > > > 1. Please don't top post. > > 2. You are correct. > > He's correct in that he's mistaken. Snapshot replication > (basic replication) *is* available in Standard Edition, 9i. > Advanced replication (master2master) is only in EE. > 10g might have changed that, but that will be another > reason for people not to upgrade... > Noons, 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 This is why I generally don't consider snapshot copies as being replication. They generally only replicate the data, and not the engine logic associated with the base table.
Noons wrote: > DA Morgan wrote: > >>Madison Pruet wrote: >> >>>I didn't know that Oracle replication was available on the standard edition. >>>I thought that it was only available on the enterprise edition. Am I >>>mistaken? >> >>1. Please don't top post. >>2. You are correct. > > > He's correct in that he's mistaken. Snapshot replication > (basic replication) *is* available in Standard Edition, 9i. > Advanced replication (master2master) is only in EE. > 10g might have changed that, but that will be another > reason for people not to upgrade... You are correct. I've been into 10g so long when I see replication I think Streams and DataGuard. Appreciate the correction. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)
On Mon, 01 Aug 2005 00:10:29 -0700, Noons interested us by writing: > > DA Morgan wrote: >> Madison Pruet wrote: >> > I didn't know that Oracle replication was available on the standard edition. >> > I thought that it was only available on the enterprise edition. Am I >> > mistaken? >> >> 1. Please don't top post. >> 2. You are correct. > > He's correct in that he's mistaken. Snapshot replication > (basic replication) *is* available in Standard Edition, 9i. > Advanced replication (master2master) is only in EE. > 10g might have changed that, but that will be another > reason for people not to upgrade... Just to expand on that a bit: a) from the Oracle9i R2 New Features manual: ----------------- Basic replication - SE and EE Oracle9iserver fully supports bi-directional replication with automated conflict detection and resolution. Supported configurations include a single updatable master site with multiple updatable or read-only snapshot sites. Advanced Replication - EE only Advanced replication includes basic replication functionality plus multi-master replication, Replication Manager, and parallel propagation to maximize throughput. (Advanced Replication was formerly known as Replication.) ----------------- b) from the Oracle' Database Licensing Information manual for 10g ----------------- Advanced Replication (multimaster) - EE only Basic replication (which is available with Standard Edition and Standard Edition One) provides support for read-only and updatable materialized views (for replication) and multitier materialized views. Standard Edition and Standard Edition One databases can also act as a master site for materialized views, but cannot participate in multimaster replication. ----------------- -- Hans Forbrich Canada-wide Oracle training and consulting mailto: Fuzzy.GreyBeard_at_gmail.com *** I no longer assist with top-posted newsgroup queries ***