Re: Convert SAP Oracle Database to IBM DB2 Database??
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 07 Feb 2008 09:41:46 -0800
Message-ID: <1202406082.296143@bubbleator.drizzle.com>
>> 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.
Date: Thu, 07 Feb 2008 09:41:46 -0800
Message-ID: <1202406082.296143@bubbleator.drizzle.com>
Jeroen van den Broek wrote:
> On Feb 6, 5:56 pm, DA Morgan <damor..._at_psoug.org> 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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Feb 07 2008 - 11:41:46 CST