Re: Adjusting to DB2

Rodrick Brown wrote:
> We are a 100% Oracle shop OLTP & data warehousing but, we will be supporting
> a new application that was build for DB2, how easy would it be to transition
> Oracle skills to DB2 skills ? is it relistic to think with a week of traning
> and few books one can easily pick up DB2 and run with it.
>
> Thanks in advance for all those who are managing both DB2 and Oracle :-)

I think a week is unrealistic if anything requires tuning or an understanding of DB2 deeper than starting and stopping the server though since DB2 is not one product on all operating systems which o/s is a critical yet unanswered question.

Most of your Oracle skills will be transportable but much of what you take for granted is not. You won't find MVCC, you won't find partitioning, you won't find RAC, you won't find RMAN, you won't find DataGuard, you won't find SQL*Loader, you won't find anything remotely approaching the richness of Oracle's instrumentation.

I'd suggest you hire in, for 90 days, a DB2 contractor to hold your hands until you are ready to stand on your own.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)