Re: OT - Oracle Gateway to a DB2 10.1 database.
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: WLJohnson@xxxxxx
- Date: Fri, 23 Nov 2012 10:54:33 +0100
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:
> 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
>
> --
> //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>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
