Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: No future for DB2

Re: No future for DB2

From: Bob Jones <email_at_me.not>
Date: Sun, 31 Jul 2005 20:34:02 GMT
Message-ID: <_AaHe.144$C11.129@newssvr21.news.prodigy.com>

>> How could running recovery drills be easier in DB2 than in Oracle?
>
> db2 has less moving parts to worry about
>

Can you be more specific on what "moving parts" are?

>> If I were to compare Oracle and DB2, ease of use or support would be the
>> last thing come to mind. The overall difference is so minor. Anybody with
>> slightly different experience would disagree with you.
>
> once again, less moving parts. less stuff to manage. of course,
> sometimes those extra parts given oracle flexibility that's useful. at
> least theoretically that's the case. In my opion, it's also much less
> forgiving - in which every single configuration change is preceeded
> with a backup, and even shutting down the database can be a pain.
> That's something that just doesn't seem common in the db2 world - to do
> backups before every change. Talking about 9i here and v8 btw.
>

None of these makes any sense to me. Doing a backup before every configuration change is a choice, an unusual one I might add, not a requirement. That's not even something specific to Oracle. Many things can be a pain if not done correctly, not just a simple task like shutting down a database.

>> No, partitioning is not included in DB2 Workgroup Edition. You can't even
>> do
>> simple replications in DB2 without purchasing a separate product.
>
> Last I checked, Workgroup Server Edition (WSE) costs $999 + $250 / user
> in the concurrent or registered model. It also supports:
> - replication
> - multi-dimensional clustering (very similar to oracle partitioning)
> - 64-bit instances
> - up to 4 cpus
> This means you could *easily* build a 2 TB data warehouse on db2 for
> under $1500 in licensing costs. And yeah, mdc is different than
> oracle's partitioning - lacks oracle's nice partition management. But
> is very easy to work with, and is great for performance. And of course
> you could also use union-all views - which are more similar to Oracle's
> partitioning. This capable is also *free*, and can be combined with
> mdc if you wish. And then if you want to take the next step and move
> into DPF (spanning multiple servers), either of these techniques can be
> *combined* with that partitioning strategy.
>

MDC and database paritioning are two different things, even in DB2 terms. DPF (Database Partitioning Feature) is only available in DB2 ESE, even then it still has to be licensed separately.

> And how much does partitioning cost / server for oracle? $10,000? so,
> what are we looking at here? $1500 for db2 vs $40,000 just for oracle
> partitioning - not even including the base product?
>

How much does DB2 paritioning feature cost per CPU? And don't forget you can also use union all views in Oracle without the paritioning feature, if you think one can replace the other. Received on Sun Jul 31 2005 - 15:34:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US