"-901 is a internal error in DB2 LUW - some error condition that DB2/Federation can not assign a proper SQL code. You need to contact IBM support resolve the problem.
BTW, you may use Federation ODBC wrapper to connect to postgres . That could have…"
Have you got any diagnostic message in the postgresql server diag log ?
If not, it looks like a connection timeout problem.
Activate JDBC trace and reissue the query.
Also contact IBM support.
I created my DB2 (Enterprise Server (Linux DB2 v220.127.116.11) + federation Infosphere) a "wrapper" with a JDBC for postgres server. The installation was a success. I have a table in postgres with 1,000,000 records. When you run a simple "SELECT * FROM TABLE FETCH FIRST 10 ROWS ONLY" or "SELECT * FROM TABLE WHERE ID < 10 " DB2 takes almost 3 minutes and leaves from a -901 sqlcode. What can I do to improve performance. Here's my script creation wrapprer : CREATE WRAPPER JDBC LIBRARY…See More