Re: OT - Oracle Gateway to a DB2 10.1 database.

From: Stephane Faroult <>
Date: Fri, 23 Nov 2012 10:54:33 +0100
Message-ID: <>


    AFAIK IBM is working hard on making DB2 compatible with Oracle (rather funny when you see how Oracle was happily cloning SQL/DS and DB2 twenty-five years ago). There is a DB2_COMPATIBILITY_VECTOR parameter that can be set (db2set DB2_COMPATIBILITY_VECTOR= ORA) . There is an article about this here:

I know very well that everything works better in the docs than in reality but it's just possible that running DB2 in "Oracle-compatible" mode would, if not make the migration instant (I doubt it), at least make the code changes really minimal without adding a "gateway" layer (which doesn't come free either, does it?)


Stephane Faroult
RoughSea Ltd <>
Konagora <>
RoughSea Channel on Youtube <>

On 11/21/2012 07:03 PM, Johnson, William L (TEIS) wrote:

> Ok - so we have an odd situation and I am hoping someone has some good experience and maybe some good examples or references.
> We have a mainframe system running Cobol programs that currently connect to an Oracle 11gR2 database. Compliments of a migration, the Oracle 11gR2 database is moving to IBM DB2 10.1.
> We are struggling with the coding changes required to the Cobol programs and found out that IBM never wrote a DB2 client for the mainframe to access a LUW DB2 database.
> So, we are now looking to implement an Oracle Gateway to DB2 to try and avoid major changes to the Cobol code.
> Does anyone have experience setting up the Oracle Gateway to DB2 and all of the associated tasks that must occur on the DB2 side of the house?
> It the Oracle Gateway does not work, we can setup a DB2 ZOS database and configure a pass-through to the LUW DB2 database - but we will have to make significant code changes and still configure things on the DB2 database. None of which we are familiar with today.
> Does anyone have experience in either of these areas?
> Thanks in advance!
> Bill
> --
-- Stephane Faroult RoughSea Ltd <> Konagora <> RoughSea Channel on Youtube <> --
Received on Fri Nov 23 2012 - 10:54:33 CET

Original text of this message