Articles & Content


Enabling Oracle Applications on DB2 - an Early User Experience (C03)

Topic: 2010 NA

Subtopic: DB2 for LUW

DATE: 2010-5-11 (03:00 PM - 04:00 PM)
SPEAKERS: Bernie O'Connor (Anixter Inc.)

Until the DB2 9.7, there was a large divide between Oracle applications and the rest of the Relational World. Syntax was one obstacle, and Concurrency approach was another. Now, there is a workable alternative. This presentation discusses Anixter's early user experiences for at least two applications. Topics will include: Datatypes Syntax Concurrency Moving Data between Oracle and DB2 Participation in the Cobra beta - a great experience Also, as we continue, we may be able to speak to differences in XML capabilities.

EXP. LEVEL: Beginner


Datatypes differences, and migration to DB2 from Oracle. Although these have been greatly minimized, there are a couple of differences worth noting.

Syntax. Most of the migration worked without intervention. There are some syntax differences that need attention. They include functions in views, for example.

Concurrency. Enabling DB2 to run with a similar concurrency approach permitted applications to truly run.

Moving Data between Oracle and DB2. It was a little hard to manage at first, but it got easier.

Participation in the Cobra beta - a great experience. What it's like to participate in a beta, and the benefits for IBM and the customer organization.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.