DB2 Database access from various mainframe machines

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
perumalnk
Member
Posts: 24
Joined: Thu Feb 28, 2008 3:30 am
Location: Denver,USA

DB2 Database access from various mainframe machines

Post by perumalnk » Thu Dec 04, 2008 2:24 am

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.

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

Post by Natarajan » Thu Dec 04, 2008 1:19 pm

Hi Perumal,


As i know, if you have IP address, user-id and password to connect to the server.
we can connect to any server, it may be in mainframe or LINUX, it does not matter.

Any other views....
Natarajan
Chennai

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Thu Dec 04, 2008 11:43 pm

Hi,

If by "different Machines" you mean different LPARs, you might use "route cards" as well.
Regards,
Anuj

perumalnk
Member
Posts: 24
Joined: Thu Feb 28, 2008 3:30 am
Location: Denver,USA

Post by perumalnk » Fri Dec 05, 2008 9:22 am

Hi Natarajan,

Thanks for your reply. But Is it possible to establish that kinda connectivity in a COBOL code? I am not sure about this. Any ideas?

Thanks,
Perumal.N.K.

perumalnk
Member
Posts: 24
Joined: Thu Feb 28, 2008 3:30 am
Location: Denver,USA

Post by perumalnk » Fri Dec 05, 2008 9:26 am

Hi Anuj,

Thanks for your reply. Could you please let me know what exactly you mean by "Route cards"?

Thanks,
Perumal.N.K.

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

DB2 SQL CONNECT DRDA Programming

Post by Natarajan » Fri Dec 05, 2008 9:44 am

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
Natarajan
Chennai

perumalnk
Member
Posts: 24
Joined: Thu Feb 28, 2008 3:30 am
Location: Denver,USA

Post by perumalnk » Tue Dec 30, 2008 1:39 am

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.

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

Post by Natarajan » Tue Dec 30, 2008 4:20 pm

Thanks Perumal for sharing the info with us.
Natarajan
Chennai

Post Reply

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



Other References
Mainframe Tools and others