JDBC connection from Windows Server 2019 and 2022 to IBM i is slow

Copper Contributor

Trying to upgrade from Windows Server 2016 to 2022. Server in question is an ETL server running Talend Open Studio with JDBC connections to MS SQL Server and IBM DB2 on IBM i. We spun up a test server with Windows 2022, installed Java, Talend, and a test model. It literally runs 100x slower than the 2016 server. Even though the new server hardware is significantly faster than the old server. That number is based on the old server getting throughput rates of 1000-1500 rows per second, and the new server getting only around 15-20 rows per second. By watching the connections and the data flows, it appears that the problem is the connection between Windows and IBM i, but only when using Windows 2022. 

 

We installed Windows 2016 on the new hardware, and it gets about 2000 rows per second throughput. we also tried Windows 2019, and it was similar in performance to Windows 2022. What changed between 2016 and 2019 that would cause a problem like this. We can just not use the newer Windows with this performance issue.

 

Windows is the only variable in the tests. Drivers, source and target databases, JVM versions all the same between tests.

0 Replies