as David says: Federation Server can provide this connectivity. We
use it in our shop and it proves to be very stable and well
performing. And of course you are not limited to Oracle, but can
access a wide variety of relational and non-relational data sources
(SQL Server, Informix, XML, MQ, Excel Sheets, Flat files, and many
more). Just in case...
One drawback might be that this is a relatively pricey product. So,
to keep license cost at bay, you might want to consider PVU
licensing with sub-capacity management. We are running one single,
centralized Federation Server per stage (dev, pre-prod, prod), each
of them being a virtualized box with as little CPU as possible.
Allows us to only license the number of CPU cores we actually have
assigned to the individual boxes.
The good news is that IBM are quite forward-looking with
sub-capacity management (as opposed to - let's say - Oracle...) and
they accept this licensing mode for about any relevant
virtualization technology available.
My five cents,
To: [login to unmask email]
Subject: [DB2-L] - RE: Accessing Oracle data on Unix from DB2 v9
From: [login to unmask email]
Date: Tue, 13 Dec 2011 14:43:23 -0700
One option is to install a copy of IBM's InfoSphere Federation
Server on UNIX. z/OS apps can access a Federation Server database
through DRDA the same way z/OS apps can access a DB2 LUW database.
The Federation Server database can provide transparent access to
Oracle databases (and others). It accepts DB2 SQL and, optionally,
can be configured to provide Oracle SQL compatibiliy just as DB2
In Reply to Donna Domovic:
We currently have DB2 v9 for z/OS and Oracle SQL*Net running on the
mainframe and use the combination of this to access Oracle data on
Unix from our mainframe applications including Cobol programs. In
addition to DB2, we also have MQ and Web Sphere.
Oracle is no longer supporting SQL*Net on the mainframe so we'd
like to find another method that will allow the Oracle data to be
accessed from the mainframe applications.
Has anyone done this or do you have suggestions? While we would
like to save costs by taking advantage of what we already have in
house, we are open to all suggestions.
Thanks in advance for your help.
Site Links: View post online View mailing list online Send new post
via email Unsubscribe from this mailing list Manage your
Use of this email content is governed by the terms of service