HTTP Call with JCL or Cobol or access to Linux DB2-Server



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

HTTP Call with JCL or Cobol or access to Linux DB2-Server

Postby olivermf » Tue Feb 15, 2011 7:25 pm

Hello,

we use a windows application that fetches some data from our mainframe and use this data to update database fields on our Linux-based Oracle DB2-Server. Is it possible to write into this database directly from the mainframe via JCL or Cobol or make a HTTP-Call to invoke a JSP or PHP-Script on an Apache-Server, running on the linux server?

I hope one can understand what I mean ...

kind regards

Oliver
olivermf
 
Posts: 53
Joined: Tue Feb 08, 2011 4:28 pm
Has thanked: 3 times
Been thanked: 0 time

Re: HTTP Call with JCL or Cobol or access to Linux DB2-Server

 

Re: HTTP Call with JCL or Cobol or access to Linux DB2-Serve

Postby enrico-sorichetti » Tue Feb 15, 2011 7:36 pm

DRDA ( Distributed Relational Data Access )
If You have a DB2 instance running ,
by a few proper customization You will be able to access relational databases almost everywhere in Your network!
Naturally more investigation will be necessary for the details, but the backbone is already built inside DB2!
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2643
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: HTTP Call with JCL or Cobol or access to Linux DB2-Serve

Postby olivermf » Tue Feb 15, 2011 7:42 pm

Thank you for your fast reply.

Do you mean that I use the DB2 instance running on the mainframe to access the database running on another server in my network?
olivermf
 
Posts: 53
Joined: Tue Feb 08, 2011 4:28 pm
Has thanked: 3 times
Been thanked: 0 time

Re: HTTP Call with JCL or Cobol or access to Linux DB2-Serve

Postby enrico-sorichetti » Tue Feb 15, 2011 7:55 pm

yes!
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2643
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: HTTP Call with JCL or Cobol or access to Linux DB2-Serve

Postby olivermf » Tue Feb 15, 2011 9:25 pm

Thank you! I will try...
olivermf
 
Posts: 53
Joined: Tue Feb 08, 2011 4:28 pm
Has thanked: 3 times
Been thanked: 0 time

Re: HTTP Call with JCL or Cobol or access to Linux DB2-Serve

Postby GuyC » Tue Feb 15, 2011 10:59 pm

DB2 to DB2 is best using DRDA http://publib.boulder.ibm.com/infocente ... atasql.htm

Process to Process we use IBM® WebSphere® MQ
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: HTTP Call with JCL or Cobol or access to Linux DB2-Serve

Postby olivermf » Wed Feb 16, 2011 12:02 pm

Thanks to both of you.
So far i'm informed now.

The next question is, if this is possible to link other databases too.
Can I access an Oracle Database Server running on Linux using sometihing like DRDA on the z/OS DB2?
olivermf
 
Posts: 53
Joined: Tue Feb 08, 2011 4:28 pm
Has thanked: 3 times
Been thanked: 0 time

Re: HTTP Call with JCL or Cobol or access to Linux DB2-Serve

Postby enrico-sorichetti » Wed Feb 16, 2011 7:44 pm

the best place to look for might me

for the IBM side
the db2 manuals themselves
the IBM redbook publications

IIRC db2 interfaces nicely to informix,
for oracle there should be something like Oracle Transparent Gateway for IBM DRDA
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2643
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post