Connect Z/OS to Oracle on UNIX [message #643880] |
Tue, 20 October 2015 09:26 |
|
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 #643933 is a reply to message #643924] |
Thu, 22 October 2015 03:00 |
John Watson
Messages: 8962 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>
|
|
|