Home » Infrastructure » Other Operating Systems » Connect Z/OS to Oracle on UNIX (Z/OS mainframe,cobol/DB2)
icon5.gif  Connect Z/OS to Oracle on UNIX [message #643880] Tue, 20 October 2015 09:26 Go to next message
ajaysh.83@gmail.com
Messages: 4
Registered: October 2015
Location: USA
Junior Member
I have a doubt about connection between two systems.

System1: Z/OS mainframe, cobol/DB2.
System2: UNIX server, oracle 9i

In system1 I need data from system2 (oracle database). I need data from Oracle on UNIX to supply information to COBOL based application on the Mainframe. How can I connect applications in system1 (Z/OS) to oracle in system2. Is that possible???,I have never done anything similar, is there any disadvantage in this architecture??, other options??. My other option is changing 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
Re: Connect Z/OS to Oracle on UNIX [message #643883 is a reply to message #643880] Tue, 20 October 2015 09:55 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

I haven't seen 9i for a long time, but if I remember correctly it had a gateway to DB2. So from the Oracle side, you can insert data into your DB2 tableas. If you don't have the software, you'll have to raise a TAR to get it because it will no longer be publicly available.
Re: Connect Z/OS to Oracle on UNIX [message #643884 is a reply to message #643883] Tue, 20 October 2015 10:04 Go to previous messageGo to next message
ajaysh.83@gmail.com
Messages: 4
Registered: October 2015
Location: USA
Junior Member
Thanks John,

We are planning to upgrade .. How about Oracle 11i / 12i ? Are there more option with these versions?
Re: Connect Z/OS to Oracle on UNIX [message #643885 is a reply to message #643884] Tue, 20 October 2015 10:08 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
What more would you want?

Be sure to check your network protocols, I think 9.x supported LU6.2, but that ain't available in the current releases.
Re: Connect Z/OS to Oracle on UNIX [message #643889 is a reply to message #643885] Tue, 20 October 2015 13:04 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:

How about Oracle 11i / 12i


Probably it doesn't matter much, but - 9i was the last "i" version. 10g, 11g and 12c were the subsequent version names.
Re: Connect Z/OS to Oracle on UNIX [message #643916 is a reply to message #643889] Wed, 21 October 2015 09:00 Go to previous messageGo to next message
ajaysh.83@gmail.com
Messages: 4
Registered: October 2015
Location: USA
Junior Member
Thanks John & Littlefoot ....for your valuable advices. Below is the detailed context on the challenges, I am seeking answers for :

Challenge: We need a way for our batch and online db2 programs to connect to an Oracle database with JDBC or some other connection so that we can read data from their tables and use that data for our batch and online processing

Option1: IBM solution for connecting from a DB2 program to an Oracle database using DB2 Federation server which allows to create nicknames in a LUW db for other DBMSs such as Oracle. The DB2 program refers to the nickname for the Oracle table as though it was a DB2 table in terms of SQL used and the Federation server makes the call to the Oracle table and returns the data. It is expensive..

Can Anyone help with similar option but more reliable , robust & cost effective
Re: Connect Z/OS to Oracle on UNIX [message #643921 is a reply to message #643916] Wed, 21 October 2015 09:43 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
In what way is that solution not reliable , robust & cost effective?
Re: Connect Z/OS to Oracle on UNIX [message #643924 is a reply to message #643921] Wed, 21 October 2015 10:50 Go to previous messageGo to next message
ajaysh.83@gmail.com
Messages: 4
Registered: October 2015
Location: USA
Junior Member
Hi John,

Our team is looking for more options of accomplishing this challenge ?

Are you aware of any other way to accomplish this task ?

Thanks again
Re: Connect Z/OS to Oracle on UNIX [message #643925 is a reply to message #643924] Wed, 21 October 2015 11:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ajaysh.83@gmail.com wrote on Wed, 21 October 2015 08:50
Hi John,

Our team is looking for more options of accomplishing this challenge ?

Are you aware of any other way to accomplish this task ?

Thanks again


PERL can connect concurrently to both DB2 & Oracle; which allows you to read from one database & write to the other database.
Re: Connect Z/OS to Oracle on UNIX [message #643933 is a reply to message #643924] Thu, 22 October 2015 03:00 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Can your DB2 program issue http requests? If so, it could read the Oracle data through a web service, or just by issuing ordinary URLs. A simple example, working in the SCOTT schema:
orclz>
orclz> select dbms_xdb_config.gethttpport from dual;

GETHTTPPORT
-----------
       8000

orclz> exec  dbms_epg.create_dad('scott_dad','/scott/*')

PL/SQL procedure successfully completed.

orclz>
orclz> create or replace procedure scott.hello_world as begin
  2  htp.print('Hello world at '||to_char(systimestamp));
  3  end;
  4  /

Procedure created.

orclz> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

C:\Users\john>
C:\Users\john>wget http://SCOTT:tiger@127.0.0.1:8000/scott/hello_world
--08:56:10--  http://SCOTT:*password*@127.0.0.1:8000/scott/hello_world
           => `hello_world'
Connecting to 127.0.0.1:8000... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to 127.0.0.1:8000... connected.
HTTP request sent, awaiting response... 200 OK
Length: 51 [text/html]

100%[==========================================================================================================>] 51            --.--K/s

08:56:10 (1005.48 KB/s) - `hello_world' saved [51/51]


C:\Users\john>
C:\Users\john>type hello_world
Hello world at 22-OCT-15 08.54.20.819000000 +01:00

C:\Users\john>
Previous Topic: Pro * Cobol
Next Topic: How to connect oracle database from Mac OS X?
Goto Forum:
  


Current Time: Thu Mar 28 13:26:01 CDT 2024