Re: Adjusting to DB2

On Sun, 23 Oct 2005 04:34:47 +0000, Rodrick Brown interested us by writing:

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

What is a 'DB2 skills' and a 'Oracle skills' in YOUR context?

The issue here is there are several different skill sets involved - including development, data administration, security administration and system administration, as well as 'end user' (plus others).

Several of these can be 'transferred' within the criteria you mention.

Due to the differences in locking and internal serialization used to accomplish even such simple things as a SELECT statement, and due to the fact that the *implications* of such locking differences are rarely documented, developer skills will require a whole lot more than a week.

If you take advantage of any of the Oracle security model, your security administrator skills will need more than a week to rethink the implications as well, but from a completely different perspective.

Suggest a close read of any of Thomas Kyte's Oracle books (such as http://apress.com/book/bookDisplay.html?bID=10008) to understand some of the implications from Oracle's perspective. I do not know whether there is a counterpart in DB2. (Serge?)

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***