Re: No future for DB2

> How could running recovery drills be easier in DB2 than in Oracle?

db2 has less moving parts to worry about

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

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

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?

Note that buying just the vanilla database doesn't get you all the data warehousing bells and whistles that oracle & db2 can offer. Then again, those features are expensive and of debatable value anyway. Received on Sun Jul 31 2005 - 11:11:30 CDT