Do you like to learn by doing?
Our labs and exercises give you the chance to do just that: Learn by performing actions on real environments.
Hands-on, scenario-based labs give you experience on real environments provided by us so you don't have to worry about breaking anything.
COURSE of the MONTH
12 days, 18 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
ODBC connection to the mainframe, DB2
Posted on 2009-04-02
how to read data directly from mainfram DB2 using ODBC?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3
2-
2
- +1
12 Comments
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!
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!
Active today
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.
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.
Active 1 day ago
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
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
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.
Active today
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.
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.
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
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
Active 1 day ago
> 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
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
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Configuring and using Oracle Database Gateway for ODBC
Introduction
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup
Suggested Courses
Course of the Month12 days, 18 hours left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.