Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Db2, Oracle, SQL Server

Re: Db2, Oracle, SQL Server

From: Niall Litchfield <>
Date: Mon, 7 Feb 2005 18:23:43 -0000
Message-ID: <4207b219$0$16582$>

"Serge Rielau" <> wrote in message
> Valentin Minzatu wrote:
> > I would like not to be the match, but to get answers.
> I tried hard. And I waive counter questions. But in return I'll provide
> details so we all learn instead.
>> Just to add on the "Oracle's the best" item list:
>> - Data Guard/Streams support DDL, while DB2's corresponding feature does
>> only support DML
> Correct for replication only. I'm told Data Guard is best compared with
> HADR. HADR stubbornly applies all logs, including catalog changes.
> Thus it covers all DDL. HADR comes in three flavors: Asynchronous,
> near-synchronous and synchronous. If Informix is any judge most customers
> will use near-synchronous.
> In that case the primary server waits for the seondary to acknowledge
> receipt of a log record. To loose a transaction the secondary and primary
> have to die simultaneously.
> Asynchronous means that the primary puts the log on the wire and trusts in
> the network. Synchronous means the secondary confirms persistence of the
> log.

That does sound analogous to DataGuard, Streams is a somewhat different technology IMO, I have no idea whether IBM has anything similar. Whilst both technologies deal with data moving from one place to another - streams is about doing workflow across systems (in my view anyway) not about replication for HA or DR. There is a very good intro at which may confirm whether I'm talking garbage or not.

>> - Does DB2 provide with any functionality similar to Oracle's external
>> tables?
> Capability I think (?) yes for reads. DB2 supports external table UDF.
> There is no CREATE TABLE language hooking directly into the load facility.
> I don't know what Oracle's write capabilities are.

They are there in 10, but I'm not impressed. You can load from any flat file format, the 'flat file' that gets written to is in Oracle 'proprietory' format. (i.e no choice of .csv tab delimited or whatever. )

Niall Litchfield
Oracle DBA 
Received on Mon Feb 07 2005 - 12:23:43 CST

Original text of this message