Wondering anyone has used the UDB version drivers to connect to DB2 verses SODBC (Slow ODBC) or the limited IBM Connector? Have you had any difficulties and how do you feel performance is?
jschuhdodge 
(BOB member since 2005-03-18)
Welcome to BOB!
There must be dozens of posts about DB2 and UDB. Search first and if you have questions, please be more specific as to what you are looking for and mention product name (DB2 Connect?); version (Runtime; Enterprise Edition); version number (v8 fixpac5). A brief description of your system and any troubles you are having might elicit more responses. 8)
scott copeland (BOB member since 2002-08-15)
Sure there are. But, not for Data Integrator? As for specifics:
Running DI XI on Win2003 server.
Using DB2 Connect v8 fixpack5
UDB Driver is version 8
Mainframe DB2 is currently on version 8, but is in compatibility mode.
The problem I am having is that we are not able to utilize parameterized sql. We had to set the ParameterizedSQL2 to false in DSConfig. It will work, but because it is not parameterized it is very slow. This is because it has to execute three statements for every insert. ParameterizedSQL doesn’t require this and is faster.
Thanks!
jschuhdodge (BOB member since 2005-03-18)