Re: Convert SAP Oracle Database to IBM DB2 Database??

From: DA Morgan <>
Date: Thu, 07 Feb 2008 09:41:46 -0800
Message-ID: <>

Jeroen van den Broek wrote:

> On Feb 6, 5:56 pm, DA Morgan <> wrote:

>> Charles Davis wrote:
>>> Hello,
>>> I would like to hear from anyone here who has converted their SAP Oracle
>>> database to IBM DB2 database?
>>> Did you realize greater disk saving via DB2 compression?
>>> Did you run the latest version of DB2 rather than allow SAP to keep your
>>> Oracle version back-leveled?
>>> Please, DB2 Bashers need not apply, looking for the business case anyone
>>> used to convert to DB2.
>>> Thank you.
>>> Charles
>> Version information is relevant.
>> My testing of Oracle compression versus DB2 compression indicates that
>> DB2 has some catching up to do.
> Hmm, like you said yourself: version (and platform!) information is
> relevant. What's your test environment for DB2? (assuming 11g for
> Oracle, probably on Linux?)

9 on RHEL 4

>> But as gazzag indicates ... surely you are not considering a
>> multimillion dollar implementation change solely on the basis of a
>> few TB of disk. If that's the case I've no doubt someone at Oracle
>> will gladly buy you the disk you need.

> Compression is not only to do with disk space reduction, it can also
> effect the performance of both online transactions and batch
> processing.

Again: If that is the only problem you are about to waste a minimum of several million dollars.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Thu Feb 07 2008 - 11:41:46 CST

Original text of this message