Hi Bubba, We are using DB2 7.4 on VM and also have 3 servers, test, production, and operations. The databases are accessed from CMS applications as well as VSE (CICS and batch). As someone already mentioned, you can use DB2 Connect by turning on DRDA support on the DB2 servers.
We run DB2 Connect Enterprise Edition on a Windows box. Then you install the DB2 Connect client on your PC and it provides an system ODBC connection that your applications can use. We have used EXCEL and ACCESS in the past and it worked pretty well. Today we use DB2 Connect to allow some of our web based applications to hit the Mainframe. We also just starting using SQL Server Integration Services (SSIS) to get to DB2 as well. If you want to talk, give me a call. Are you going to WAVV this year? Ed Zell Illinois Mutual Life (309) 636-0107 ________________________________ From: The IBM z/VM Operating System [mailto:[email protected]] On Behalf Of Robert Payne Sent: Tuesday, March 16, 2010 11:19 AM To: [email protected] Subject: maybe off topic ? We are running DB2 7.2 servers (virtual machines, 1 test and 1 production) on our z9 BC with z/VM 5.2 to support VSE guests. One of the PC programmers was asking me how (if possible) they could access / update these mainframe data bases from the PC side. My assumption is that it's possible since we run batch VSE jobs that access / update the PC databases. Comments welcome. Thanks, Bubba . CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you receive this e-mail in error, notify the sender and delete this e-mail from your system.
