Page 1 of 1
DB2 Database access from various mainframe machines
Posted: 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?
Posted: Thu Dec 04, 2008 1:19 pm
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....
Posted: Thu Dec 04, 2008 11:43 pm
If by "different Machines" you mean different LPARs, you might use "route cards" as well.
Posted: Fri Dec 05, 2008 9:22 am
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?
Posted: Fri Dec 05, 2008 9:26 am
Thanks for your reply. Could you please let me know what exactly you mean by "Route cards"?
DB2 SQL CONNECT DRDA Programming
Posted: 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.
Please dont forget to update this thread, once your problem solved.
These kind of topics are helpful to others. Thanks
Posted: Tue Dec 30, 2008 1:39 am
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.
Posted: Tue Dec 30, 2008 4:20 pm
Thanks Perumal for sharing the info with us.