I’m trying to extract data from IBM System i (formerly AS400) which uses DB2 database called “DB2 UDB for iSeries” or “DB2 Universal database for iSeries”. I can connect through iseries odbc and import tables without a problem in designer but I’m at the point of configuring connectivity for the Informatica server to be able to source from this system. Using regular odbc connection fails with “FnName: Fetch Optimize -- DB2 UDB For iSeries[Driver Manager]Function sequence error]” error and to my knowledge, we would need to use native DB2 drivers for this. The guide advices to install and configure the IBM DB2 Client Application Enabler (CAE) but with this iSeries database, I’m unsure whether this would still apply. Can anyone guide me to how to extract data from iSeries or AS400? Do we need a special connector for this or can we work around odbc?
================ Fixed ================================================
The fix was to add a custom property for the Informatica integration service called “OptimizeODBCRead” and set it equals to “No” in the Administration Console.
Hi Eric, thanks for sharing solution!
Your soultion helped me in different issue: mapping failed when tried to connect to DB2/iSeries instance (with error
36401 “Session task instance [<map name>]: Execution terminated unexpectedly”.
Thank you! I spent a week trying to find an answer to this.
Just curious, to anyone on this thread, was your PowerCenter (or Cloud Secure Agent) 64 bit? Which copy of IBM Client Access 32 or 64 bit?