We are migrating DS from a Windows 2000 environment to an AIX environment. We have been and will be using DB2 connect for connections to DB2, however I am having problems trying to figure out and configure DS to use the IBM DB2 ODBC DRIVER for the ODBC connections. Can someone help me with this?
Thanks,
JB
Configure DB2 Connect Driver on AIX
Moderators: chulett, rschirm, roy
That is a sales-type of open question; the answer is "Yes", there are a number of people here who have done this and can help.
But you need to tell us what you've tried and what the results (i.e. error messages) were.
But you need to tell us what you've tried and what the results (i.e. error messages) were.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Good point. Here is what I know. We did the general installation of DS on the AIX box and included all stages. We have also installed DB2 Connect on the server and we have DS configured to look at the Instance information of DB2 Connect which we did in the dsenv file for DataStage. For the General ODBC setup, we are right now using the Wire Protocol driver that comes with DataStage by setting up the .odbc.ini file and the .uvodbc.config file(s). I do know the Path to the IBM DB2 ODBC Driver.
What I want to do; is instead of using the Wire Protocol Driver that comes with DS for the ODBC stages, I want to use the DB2 Driver that comes with DB2 connect.
What I don't know; how to get DS to use the DB2 driver. I haven't tried anything yet because I don't know where to start. So, I am, and have been, looking for instructions on how to get DS to recognize and Use the DB2 driver and I don't know what the configuration information that is needed for the Driver to work.
Is there anything else that I could provide to give anyone an idea of where I am at?
I appreciate the help.
Thanks,
JB
What I want to do; is instead of using the Wire Protocol Driver that comes with DS for the ODBC stages, I want to use the DB2 Driver that comes with DB2 connect.
What I don't know; how to get DS to use the DB2 driver. I haven't tried anything yet because I don't know where to start. So, I am, and have been, looking for instructions on how to get DS to recognize and Use the DB2 driver and I don't know what the configuration information that is needed for the Driver to work.
Is there anything else that I could provide to give anyone an idea of where I am at?
I appreciate the help.
Thanks,
JB
Some processes use the DB2 Stage others use the DB2/UDB driver. There are specific situation why we need to use the ODBC connection. One is that if we want to process multi row returns from a lookup, the ODBC stage is the only stage that allows this. So, we need to get the ODBC connections to use the DB2 Driver.
Thanks,
JB
Thanks,
JB
Try this. This works for us:
Code: Select all
.odbc.ini file entries
==============
[<enter DataBaseName>]
Driver=/usr/ascential/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect 4.20 DB2 Wire Protocol D20ver
Database=<enter DataBaseName>
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=<enter IP addr>
IsolationLevel=CURSOR_STABILITY
Instance = <enter instance name>
LoginID=
Password=
TcpPort=<enter port>
uvodbc.. file
===============
<<enter DB Name>>
DBMSTYPE = ODBC
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: