DB2 Database access from various mainframe machines
Moderators: Kalicharan, Moderator Group
DB2 Database access from various mainframe machines
Having a DB2 database sitting in one mainframe machine, what are the possible ways by which this database could be accessed by batch jobs running on other different mainframe machines?
Thanks,
Perumal.N.K.
Thanks,
Perumal.N.K.
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
DB2 SQL CONNECT DRDA Programming
You may need to use EXEC SQL CONNECT command for this.
Server should be opened for distributed access - DRDA - ( Distributed Relational Databes Access ).
You may get some more info in the followng links
http://publib.boulder.ibm.com/infocente ... onnect.htm
http://publibz.boulder.ibm.com/cgi-bin/ ... 0206045703
I suggest you to take the help of DBA for these kind of connectivity issues.
Suggestion : Please dont forget to update this thread, once your problem solved.
These kind of topics are helpful to others. Thanks
Server should be opened for distributed access - DRDA - ( Distributed Relational Databes Access ).
You may get some more info in the followng links
http://publib.boulder.ibm.com/infocente ... onnect.htm
http://publibz.boulder.ibm.com/cgi-bin/ ... 0206045703
I suggest you to take the help of DBA for these kind of connectivity issues.
Suggestion : Please dont forget to update this thread, once your problem solved.
These kind of topics are helpful to others. Thanks
Natarajan
Chennai
Chennai
Hi,
Thanks for all your replies.
I further consulted few experts on this and what I heard was, " Having multiple DB2 sub systems across multiple Mainframe machines, we can acheive DB2 connectivity by establishing a "Remote Hop" between any two DB2 sub systems. By doing this, tables residing in any DB2 system can be accessed from other Mainframe machines by referring the tables with exact address.
Thanks,
Perumal.N.K.
Thanks for all your replies.
I further consulted few experts on this and what I heard was, " Having multiple DB2 sub systems across multiple Mainframe machines, we can acheive DB2 connectivity by establishing a "Remote Hop" between any two DB2 sub systems. By doing this, tables residing in any DB2 system can be accessed from other Mainframe machines by referring the tables with exact address.
Thanks,
Perumal.N.K.
FREE TUTORIALS
Tutorials
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts. - Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3. - DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. - SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples - CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page