Re: Convert SAP Oracle Database to IBM DB2 Database??
From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Thu, 07 Feb 2008 21:32:24 -0500
Message-ID: <611ta1F1sn9cmU1@mid.individual.net>
>
> 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....
Date: Thu, 07 Feb 2008 21:32:24 -0500
Message-ID: <611ta1F1sn9cmU1@mid.individual.net>
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
-- Serge Rielau DB2 Solutions Development IBM Toronto LabReceived on Thu Feb 07 2008 - 20:32:24 CST