Neil,

It is most certainly possible. You will need to utilize DRDA
functionality of MVS with Unix DB2 acting as an Application Server and
MVS working as an Application Requestor.

There is an IBM Red Book describing how to set up DRDA access from the
MVS including all CDB (Communication Data Base) entries that need to be
created in the MVS DB2 catalog.


You can download it for free from the Web.

You will also need to do 2 BIND's: 1) on the MVS side to include the
application package that will be accessing Unix DB2 into the general
local DB2 plan and 2) Bind the same application package remotely to the
Unix DB2 database.

Hope this helps.

PerlUser

-----Original Message-----
From: Burrows Neil
[mailto:db2udbdba-ezmlmshield-x55368008.[Email address protected]
Sent: Monday, May 24, 2004 6:04 PM
To: LazyDBA Discussion
Subject: Mainframe access to Open DB2 databases

Hello,
Is possible to access a db2 database located on a unix server from an
MVS
server?
(the opposite of DB2 connect)

Neil Burrows
Data Architect




The information in this electronic mail message is sender's business
Confidential and may be legally privileged. It is intended solely for
the
addressee(s). Access to this Internet electronic mail message by anyone
else is unauthorized. If you are not the intended recipient, any
disclosure, copying, distribution or any action taken or omitted to be
taken
in reliance on it is prohibited and may be unlawful.
The sender believes that this E-mail and any attachments were free of
any
virus, worm, Trojan horse, and/or malicious code when sent. This message
and
its attachments could have been infected during transmission. By
reading
the message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses
and
other defects. Galileo International is not liable for any loss or
damage
arising in any way from this message or its attachments.




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]




DB2 & UDB email list listserv db2-l LazyDBA home page