Re: OT - Oracle Gateway to a DB2 10.1 database.
From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Fri, 23 Nov 2012 10:54:33 +0100
Message-ID: <50AF47D9.2080606_at_roughsea.com>
Bill,
Date: Fri, 23 Nov 2012 10:54:33 +0100
Message-ID: <50AF47D9.2080606_at_roughsea.com>
Bill,
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:
http://www.ibm.com/developerworks/data/library/dmmag/DMMag_2009_Issue2/InTrans/index.html
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?)
HTH,
-- Stephane Faroult RoughSea Ltd <http://www.roughsea.com> Konagora <http://www.konagora.com> RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd> On 11/21/2012 07:03 PM, Johnson, William L (TEIS) wrote:Received on Fri Nov 23 2012 - 10:54:33 CET
> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Stephane Faroult RoughSea Ltd <http://www.roughsea.com> Konagora <http://www.konagora.com> RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd> -- http://www.freelists.org/webpage/oracle-l