If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Accesing from Z/OS (Cobol-DB2) to Oracle database (UNIX)

I have a doubt about connection between two systems.

System1: Z/OS mainframe, Cobol/DB2.
System2: AIX server, Oracle 9i

In system1 I need data from system2 (Oracle database). I need data from three tables (three sql’s) one of the table has 5 millions records, and my sql will ask for 1 million (aprox). I’m thinking in using a Oracle client installed in system1 (Z/OS) that will connect with Oracle server in system2. Is that possible???,I have never done anything similar, is there any disadvantage in this architecture??, other options??. My other option is exchanging flat files with the data between the two systems. I don’t like very much, because the applications may grow and need more data, and that will mean more files….

the best would be to install somewhere on luw platform a db2 and federation server
so from z/os you can connect to this db2 and to the nicknames for the oracle db and other
there is almost no possibility to select from oracle db2 data
db2 will have to take the start ...

Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certifiedhttp://www.infocura.be