Mainframe _to_ C/S ODBC connectivity? 
Author Message
 Mainframe _to_ C/S ODBC connectivity?

Greetings,

This might not be the best NG to post this request, but I figured the
members of this NG might have some experience with this.

There are LOTS of ways to connect from a workstation or C/S environment
to a mainframe DB2 environment, but does anyone know how to connect from
a mainframe batch COBOL/JCL job to a C/S database like Oracle, SQL Server,
or DB2 UDB running on Win NT or Unix?

We are in a mixed platform shop where we might need to initiate access to
a server DB from a mainframe process as opposed to the more common
reverse situation.  I have been thinking or executing a batch utility
that runs 'REXEC' to kick off a shell script down on a Unix server, but I
was hoping for something that I could call directly from inside a COBOL
program to issue SQL queries against the server DB.

Thanks,

Tom Porter



Tue, 14 Sep 2004 12:29:33 GMT
 Mainframe _to_ C/S ODBC connectivity?

Tom,

There is an architecture called DRDA. It is the architecture upon which IBM's
connectivity solution from c/s to mainframe DB2 is based. That same
architecture provides for connectivity going the other way. One must set up
the mainframe as a DRDA-AR (application requestor) and the distributed
database as a DRDA-AS (application server). However, it requires that DB2 on
the mainframe be used as the requestor (i.e. the communications and aliasing
must be set up within DB2/390 and therefore your COBOL program would have to
run under DB2/390 in order to access DB2 distributed). This is done by using
the DRDA-AS feature of DB2 UDB on WinNT/Unix.

Similarly, if one purchases IBM's Datajoiner product (since it is built on top
of DB2), one can also set up Datajoiner as a DRDA-AS. Datajoiner, in turn, can
access Oracle, Sybase, SQL Server, etc. running on WinNT/UNIX.

For more details, suggest you consult the appropriate publications on
distributed access within the DB2/390 pub set, and the DB2 UDB and/or
Datajoiner library for the appropriate sections.

Larry Edelstein

Quote:

> Greetings,

> This might not be the best NG to post this request, but I figured the
> members of this NG might have some experience with this.

> There are LOTS of ways to connect from a workstation or C/S environment
> to a mainframe DB2 environment, but does anyone know how to connect from
> a mainframe batch COBOL/JCL job to a C/S database like Oracle, SQL Server,
> or DB2 UDB running on Win NT or Unix?

> We are in a mixed platform shop where we might need to initiate access to
> a server DB from a mainframe process as opposed to the more common
> reverse situation.  I have been thinking or executing a batch utility
> that runs 'REXEC' to kick off a shell script down on a Unix server, but I
> was hoping for something that I could call directly from inside a COBOL
> program to issue SQL queries against the server DB.

> Thanks,

> Tom Porter



Wed, 15 Sep 2004 09:08:40 GMT
 Mainframe _to_ C/S ODBC connectivity?

Quote:

> Tom,

> There is an architecture called DRDA. It is the architecture upon which
> IBM's connectivity solution from c/s to mainframe DB2 is based. That
> same architecture provides for connectivity going the other way. One
> must set up the mainframe as a DRDA-AR (application requestor) and the
> distributed database as a DRDA-AS (application server). However, it
> requires that DB2 on the mainframe be used as the requestor (i.e. the
> communications and aliasing must be set up within DB2/390 and therefore
> your COBOL program would have to run under DB2/390 in order to access
> DB2 distributed). This is done by using the DRDA-AS feature of DB2 UDB
> on WinNT/Unix.

> Similarly, if one purchases IBM's Datajoiner product (since it is built
> on top of DB2), one can also set up Datajoiner as a DRDA-AS. Datajoiner,
> in turn, can access Oracle, Sybase, SQL Server, etc. running on
> WinNT/UNIX.

> For more details, suggest you consult the appropriate publications on
> distributed access within the DB2/390 pub set, and the DB2 UDB and/or
> Datajoiner library for the appropriate sections.

Larry,

Thanks for the info.  Rather than asking a follow-up question immediately,
I will look at the doco and see what I find.

Tom Porter



Wed, 15 Sep 2004 12:00:01 GMT
 Mainframe _to_ C/S ODBC connectivity?
Can anyone suggest tools to access DB2 databases from a Windows computer?

The IBM graphical tools are very poor (IMO).

I am looking for anything that would allow me to examine tables and fields,
run queries in immediate mode (to test stored procedures before they are
compiled)..etc..

Thanks,



Sat, 18 Sep 2004 02:34:11 GMT
 Mainframe _to_ C/S ODBC connectivity?
QMF for Windows should fit your bill. See http://www.rocketsoftware.com/qmf/
or follow the hyperlink from
http://www-3.ibm.com/software/data/db2/relatedproducts.html.


Quote:
> Can anyone suggest tools to access DB2 databases from a Windows computer?

> The IBM graphical tools are very poor (IMO).

> I am looking for anything that would allow me to examine tables and
fields,
> run queries in immediate mode (to test stored procedures before they are
> compiled)..etc..

> Thanks,



Sat, 18 Sep 2004 14:31:07 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Mainframe / PC ODBC connectivity

2. Sybase/Mainframe connectivity

3. US-CA-Burbank TECH SUP PC, MAC, TCP/IP, Connectivity to mainframe/client server SMCI

4. connectivity SUN and IBM Mainframes

5. Unix - Mainframe connectivity

6. ODBC Driver for Tetra CS on Unix

7. MA-Boston-247978--Mainframe-ORACLE-COBOL-JCL-SAS-ORACLE-MVS-Mainframe Consultant

8. VA-Herndon-93524--COBOL II-DB2-IMS DB/DC-JCL-Mainframe-IBM Mainframe-MVS-ESA-ORA

9. VA-Herndon-93524--COBOL II-DB2-IMS DB/DC-JCL-Mainframe-IBM Mainframe-MVS-ESA-ORA

10. VA-Herndon-93524--COBOL II-DB2-IMS DB/DC-JCL-Mainframe-IBM Mainframe-MVS-ESA-ORA

11. VA-Herndon-93524--COBOL II-DB2-IMS DB/DC-JCL-Mainframe-IBM Mainframe-MVS-ESA-ORA

12. VA-Herndon-93524--COBOL II-DB2-IMS DB/DC-JCL-Mainframe-IBM Mainframe-MVS-ESA-ORA


 
Powered by phpBB® Forum Software