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

In my experience 80% of the problems Oracle shops being exposed to DB2 encounter are in the mind.
What I mean by that is that if you and your team are willing to accept that not everything that is different is necessarily bad, then a week of training and some good books will go a long way. If not, well then DB2 will keep rubbing you the wrong way in anything from different SQL to locking and isolation levels.

Good books include the free and downloadable: http://ourworld.compuserve.com/homepages/graeme_birchall/HOMEPAGE.HTM

Googling the Informationcenter using "site:boulder.ibm.com" http://publib.boulder.ibm.com/infocenter/db2help/index.jsp

Redbooks:
http://publib-b.boulder.ibm.com/redbooks.nsf/portals/Data

DeveloperWorks DB2:
http://www-128.ibm.com/developerworks/db2

Well that'll keep you busy ;-)
Cheers
Serge

PS: No I'm not suffering from insomnia, I'm on assignment in China.

-- 
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab