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

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?)

>
> 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.

--
Jeroen