Using ACL to pull data from mainframe DB2

[Geer, Rebecca]

All,

hoping someone can provide some insight on this.  

 

We have been using ACL for a few years to pull data from our Oracle database using ODBC drivers, but have been unable to get a similar process set up for pulling data from our DB2 tables for our mainframe.  Our IT personnel have been trying to help with this and seem to think we need an additional piece of software.  They have talked to ACL tech support but haven't made much progress. 

 

Are any of you pulling data directly from the DB2 tables (rather than pulling in files) using an ODBC driver or some other  means to connect to the database?  If so, any information you could provide on how this works would be greatly appreciated or maybe you have an IT person who would be willing to talke to our IT person. 

 

thanks,

Sue Geer

Sr. Auditor

Nashville Electric Service

 

---

NES now offers free online billing! Save time, money and paper too!
Register today for NES E-bill at www.nespower.com.

[Watts, Larry]

Yes, we have staff using ACL to pull data from DB2 tables on the mainframe.  You will need some middleware; we are using DB2 Connect and you will need to define DB2 target database as a data source.     

 

Best Regards

Larry Watts| Internal Audit Manager IT
Bridgestone Americas Holding, Inc.
535 Marriott Drive | Nashville, TN 37214
Phone 615-937-1363 | Fax 615-493-0362

--
You received this message because you are subscribed to the Google Groups "Nashville ACL User Group" group.
To post to this group, send email to nashville-ac...@googlegroups.com.
To unsubscribe from this group, send email to nashville-acl-user...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/nashville-acl-user-group?hl=en.

[Chris Cole]

Rebecca,

I don't think drivers exist for mainframes. For most mainframe environments, there is only one way in and one way out. But for a better answer, you can contact the vendor that supports your mainframe environment to see if an ODBC driver exists.


Chris Cole, CISA | IT Audit Manager |  Community Health Systems
4000 Meridian Blvd. |  Franklin, TN  37067  |  Tel:  615-465-7342  |  Fax:  615-373-2307  |  http://www.chs.net


Disclaimer: This electronic message may contain information that is Confidential or legally privileged. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains.

"Geer, Rebecca" <SG...@NESPOWER.COM> Sent by: nashville-ac...@googlegroups.com 09/29/2010 12:19 PM Please respond to nashville-ac...@googlegroups.com

To "'nashville-ac...@googlegroups.com'" <nashville-ac...@googlegroups.com> cc

Subject Using ACL to pull data from mainframe DB2

--

You received this message because you are subscribed to the Google Groups "Nashville ACL User Group" group.
To post to this group, send email to nashville-ac...@googlegroups.com.
To unsubscribe from this group, send email to nashville-acl-user...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/nashville-acl-user-group?hl=en. -------------------------------------------------------------------------- Disclaimer: This electronic message may contain information that is Proprietary, Confidential, or legally privileged or protected. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains.

[Geer, Rebecca]

thank you.  I will forward to our IT department.

[Geer, Rebecca]

thanks, that is a good suggestion.

[Shelton, Roy C]

Rebecca,

DB2 on the mainframe usually has some utility or data extractor that IT may have, to pull out of the tables those columns of data that you need. Once they are in a flat file on the mainframe, you should ask them if you have something like Bluezone, or similar utility that will allow you to drag the flat file down to the distributed (Lan) directory for ACL to use.

 

We do that here.

 

 

 

R.C. Shelton

 

Roy Shelton

AVP - Internal Audit

Unum Group

p: 423.294.4240

 

 

---

From: nashville-ac...@googlegroups.com [mailto:nashville-ac...@googlegroups.com] On Behalf Of Geer, Rebecca
Sent: Wednesday, September 29, 2010 1:50 PM
To: 'nashville-ac...@googlegroups.com'
Subject: RE: Using ACL to pull data from mainframe DB2

[Yuan, Qian (Internal Audit)]

Rebecca,

 

Microsoft has ODBC driver for DB2 which might work with OS/400. But I think it might need a little tune up before you can use it. The name of the driver is msdb2ole.dll. You may ask your IT guy to find where to download and install this file if not already existed on your system. Hope this help a little bit.

 

Qian

 

From: nashville-ac...@googlegroups.com [mailto:nashville-ac...@googlegroups.com] On Behalf Of Geer, Rebecca

Sent: Wednesday, September 29, 2010 11:49 AM
To: 'nashville-ac...@googlegroups.com'

Subject: Using ACL to pull data from mainframe DB2

 

All,

--