Page 1 of 1

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

PostPosted: Tue Feb 15, 2011 7:25 pm
by olivermf
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

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

PostPosted: Tue Feb 15, 2011 7:36 pm
by enrico-sorichetti
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!

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

PostPosted: Tue Feb 15, 2011 7:42 pm
by olivermf
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?

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

PostPosted: Tue Feb 15, 2011 7:55 pm
by enrico-sorichetti
yes!

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

PostPosted: Tue Feb 15, 2011 9:25 pm
by olivermf
Thank you! I will try...

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

PostPosted: Tue Feb 15, 2011 10:59 pm
by GuyC
DB2 to DB2 is best using DRDA http://publib.boulder.ibm.com/infocente ... atasql.htm

Process to Process we use IBM® WebSphere® MQ

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

PostPosted: Wed Feb 16, 2011 12:02 pm
by olivermf
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?

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

PostPosted: Wed Feb 16, 2011 7:44 pm
by enrico-sorichetti
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