Page 1 of 1

DB2 Database access from various mainframe machines

Posted: Thu Dec 04, 2008 2:24 am
by perumalnk
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.

Posted: Thu Dec 04, 2008 1:19 pm
by Natarajan
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....

Posted: Thu Dec 04, 2008 11:43 pm
by Anuj Dhawan
Hi,

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

Posted: Fri Dec 05, 2008 9:22 am
by perumalnk
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.

Posted: Fri Dec 05, 2008 9:26 am
by perumalnk
Hi Anuj,

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

Thanks,
Perumal.N.K.

DB2 SQL CONNECT DRDA Programming

Posted: Fri Dec 05, 2008 9:44 am
by Natarajan
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

Posted: Tue Dec 30, 2008 1:39 am
by perumalnk
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.

Posted: Tue Dec 30, 2008 4:20 pm
by Natarajan
Thanks Perumal for sharing the info with us.