Re: Convert SAP Oracle Database to IBM DB2 Database??
From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Thu, 07 Feb 2008 22:24:01 -0500
Message-ID: <6120aqF1sjflgU1@mid.individual.net>
>
> I would but there is a rather substantial problem: Chris Eaton's
> understanding of Oracle compression appears to not even include
> the marketing materials much less the rather substantial discussion
> of the concepts and architecture.
>
> What I'm saying is that it is not just superficial ... from a technical
> point-of-view it is mostly incorrect. He needs to learn how to read the
> on-line docs.
Well the nice thing about BLOGs is the ability to give feedback. You are a teacher, no? Teach!
Date: Thu, 07 Feb 2008 22:24:01 -0500
Message-ID: <6120aqF1sjflgU1@mid.individual.net>
DA Morgan wrote:
> Serge Rielau wrote:
>> DA Morgan wrote: >>> Serge Rielau wrote: >>>> DA Morgan wrote: >>>>> Serge Rielau wrote: >>>>>> DA Morgan wrote: >>>>>>> My testing of Oracle compression versus DB2 compression indicates >>>>>>> that >>>>>>> DB2 has some catching up to do. >>>>>> Interesting, care to elaborate? Always thriving to improve... >>>>>> Given Oracle's DeWitt clause I'll gladly accept any information >>>>>> you have by email as to not get you into trouble. >>>>> Going to have to disappoint you this time for reasons I am sure you >>>>> can >>>>> appreciate. >>>> So an unsubstantiated claim... Aside you should use DB2 9.5 to >>>> compare to Oracle 11 >>> >>> If I'd used Oracle 11 I would have. >>> >>> But as long as you are actively participating how about a brief >>> technical presentation from the expert explaining to us how compression >>> in DB2 differs from that in Oracle 10g and 11g. >>> >>> Please include also information as to how headers are designed and how >>> blocks are filled? Top down as in Informix for both Top-Down and >>> Bottom-Up as in Oracle? Or some other means. >> http://blogs.ittoolbox.com/database/technology/archives/compression-in-11g-vs-db2-9-21173 >> >> Maybe we can also take the discussion there.... >> >> Cheers >> Serge
>
> I would but there is a rather substantial problem: Chris Eaton's
> understanding of Oracle compression appears to not even include
> the marketing materials much less the rather substantial discussion
> of the concepts and architecture.
>
> What I'm saying is that it is not just superficial ... from a technical
> point-of-view it is mostly incorrect. He needs to learn how to read the
> on-line docs.
Well the nice thing about BLOGs is the ability to give feedback. You are a teacher, no? Teach!
Cheers
Serge
-- Serge Rielau DB2 Solutions Development IBM Toronto LabReceived on Thu Feb 07 2008 - 21:24:01 CST