J
jlacok
Guest
Hi Santosh Thanks for your reply. We are currently using OE 11.3 Wire Protocol Driver. We have 'discovered' the following issue with it: OE Wire Protocol ODBC Driver requires that SQL Library is created on AS400 when setting up the ODBC connection. Well, it looks like when SQL Library is created, it will 'pull' all current tables/indexes from specified AS400 libraries. Any new indexes (even to existing tables) will not be added to that SQL Library 'auto magically'. I needed to add some new DB2 tables to Progress Schema holder DB, and we found out that indexes for those tables are not being added to Schema Holder. After doing some research, found a Progress KB suggesting to use IBM Driver instead if OE Wire Protocol Driver, or, to 'move' missing indexes into originally created SQL Library (which nobody here knows how to do...). So that is why we was 'playing' with IBM Driver, but, there was 3 different ones listed, plus I was hoping that someone will have suggestions for properly setting up DSN for IBM driver for best performance. Jan
Continue reading...
Continue reading...