Articles & Content


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

Topic: DB2 for LUW

Subtopic: 2010

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.

Click Here to Download

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