ODBC connection to the mainframe, DB2

how to read data directly from mainfram DB2 using ODBC?
raphael2Asked:
Who is Participating?
Advertise Here
 
giltjrConnect With a Mentor Commented:
You can, but you need to get either DB2 or DB2 Client or AIX.  The ODBC (and JDBC) drivers are supplied with the product.

Now, if you are running z/OS depending on requirements you can also extra data from DB2 using FTP.  I have not done it, but I do know that you can setup the FTP server on z/OS to connect to DB2 and then some how use GET/PUT to extract/insert data.
0
 
raphael2Author Commented:
Vee_Mod,

We are running Peoplesoft on a mainframe using DB2 database platform.  In the current implementation, we are extracting from the mainframe using Ab Initio and landing in a set of staging tables in a DB2/AIX platform.  
we are asking if we could read the data directly from the mainframe using ODBC connection to the mainframe.  PLease reply ASAP!
0
 
tliottaConnect With a Mentor Commented:
raphael2:

I'm not completely clear:

> ...Peoplesoft on a mainframe using DB2 database platform.

...and...

> ...landing in a set of staging tables in a DB2/AIX platform.

From that, it seems that DB2 is on the mainframe and DB2 is on AIX. However:

> how to read data directly from mainfram DB2 using ODBC?

Why would you want to use ODBC with DB2 on both ends? Why not just use straight DRDA?

Tom
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Access It Now
 
raphael2Author Commented:
Tom, I am asking specific question about ODBC use in this case. I do not have DRDA available for this operation. ODBC is answer i am looking for. Thanks.
0
 
giltjrConnect With a Mentor Commented:
You do realize that even the DB2 ODBC driver uses DRDA under the covers?  ODBC provides the API for the program, the ODBC driver talks to the database in a way the database understand, which in the case of DB2 is DRDA.

Again, you need to get either DB2 or DB2 Client.  There are some products, like Toad (http://www.toadsoft.com/toaddb2/index.html) that comes with a copy DB2 Client.
0
 
momi_sabagConnect With a Mentor Commented:
if you want to access db2 on a mainframe from aix using odbc you will need to buy a middleware product such as db2 connect by ibm

if you can use jdbc, then the jdbc universal driver which comes with a db2 client installation for aix will allow you to communicate with a mainframe without the need for db2 connect
0
 
tliottaConnect With a Mentor Commented:
> Again, you need to get either DB2 or DB2 Client...

But he apparently _has_ DB2, both on z/OS and AIX.

I'm unfamiliar with DB2 on AIX, so I'm surprised that DB2 on AIX has no available connectivity to DB2 on z/OS. I would have hoped that IBM would provide DB2-to-DB2.

Tom
0
 
giltjrConnect With a Mentor Commented:
DB2 on AIX does come with everything needed to connect to DB2 on z/OS if you are talking straight to DB2 or using JDBC.  I'm not sure about ODBC though.  I always associated ODBC with Windows, not *nix platforms.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.