Hi,
We are in the initial phases of migrating from Version 9.1 on Windows to 11.5 on LINUX and are looking to create an entry in our ODBC.ini file utilizing the DB2 client driver. The samples have entries utilizing the DB2 Wire protocol driver but we are looking for one for the DB2CLI.dll (that is what is currently on windows). Unfortunately this specific connection goes through our DB2 Connect gateway server to connect to Mainframe DB2 and does not work with the WIRE driver.
We are aware that the application owners can and should be using the DB2 connector and we would not need this, but in an effort to avoid redoing dozens of jobs we are trying to allow them to continue utilizing the ODBC connector.
Does anyone have a working sample of such an entry?
Thanks - - John
Entry in the odbc.ini file utilizing db2 client driver
Moderators: chulett, rschirm, roy
-
JPalatianos
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
I've never tried this, but it may work:
DB2 ODBC CLI driver Download and Installation information
http://www-01.ibm.com/support/docview.w ... wg21418043
You'd still need to be able to reference it / configure it from the .odbc.ini file. I know other 3rd party drivers (like Netezza) can be called from the .odbc.ini file, so in theory it could work.
DB2 ODBC CLI driver Download and Installation information
http://www-01.ibm.com/support/docview.w ... wg21418043
You'd still need to be able to reference it / configure it from the .odbc.ini file. I know other 3rd party drivers (like Netezza) can be called from the .odbc.ini file, so in theory it could work.
-
JPalatianos
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
Thanks Andy.
I have been looking around and cannot seem to find an entry using the db2 client driver. We are looking for something like the ODBC.ini entry shown below for the DataDirect Wire protocol but specific for the DB2 Client Driver: DB2CLIO.
[DB2 Wire Protocol]Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdb200.so Path for DB2 Client driver??
Description=DataDirect DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=OS/390 and AS/400 (Remove for DB2 UDB)
CipherList=DEFAULT:!RC4
Database=DB2 UDB (Remove for OS/390 and AS/400)
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=DB2 server host
IsolationLevel=CURSOR_STABILITY
Location=OS/390 and AS/400 (Remove for DB2 UDB)
LogonID=
Password=
Package=DB2 package name
PackageOwner=
TcpPort=DB2 server port
WithHold=1
I have been looking around and cannot seem to find an entry using the db2 client driver. We are looking for something like the ODBC.ini entry shown below for the DataDirect Wire protocol but specific for the DB2 Client Driver: DB2CLIO.
[DB2 Wire Protocol]Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdb200.so Path for DB2 Client driver??
Description=DataDirect DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=OS/390 and AS/400 (Remove for DB2 UDB)
CipherList=DEFAULT:!RC4
Database=DB2 UDB (Remove for OS/390 and AS/400)
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=DB2 server host
IsolationLevel=CURSOR_STABILITY
Location=OS/390 and AS/400 (Remove for DB2 UDB)
LogonID=
Password=
Package=DB2 package name
PackageOwner=
TcpPort=DB2 server port
WithHold=1