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.

Go Back  dBforums > Database Server Software > DB2 > Accesing from Z/OS (Cobol-DB2) to Oracle database (UNIX)

LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Registered User
Join Date: Apr 2006
Posts: 20
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Ö.

Any help, advice, will be greatly appreciated.
Thanks in advance
Reply With Quote
  #2 (permalink)  
Registered User
Join Date: Apr 2006
Location: Belgium
Posts: 2,221
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 Certified
Reply With Quote
  #3 (permalink)  
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 5,399
Originally Posted by przytula_guy View Post

there is almost no possibility to select from oracle db2 data
db2 will have to take the start ...
That's not entirely correct. Oracle Transparent Gateway can connect to DRDA data sources, and you won't need an intermediate server for federation.
"It does not work" is not a valid problem statement.
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On