I am experiencing some strange JDBC issues that frankly have me baffled. I
am using Talend Open Studio to do some ETL with IBM i as the load target.
It all runs with acceptable speed. I am getting a rate of over 1000 rows
per second, but the server we are using to run the jobs is a bit limited,
and development speed is a little slow.
So we just got a new server to do the Talend development and execution on.
It is a beastly server with plenty of cores, threads, RAM and disk space.
In fact it is much faster than the previous server. Except that now I am
only getting an insert rate of 10-20 rows per second on IBM i. Same driver,
same IBM i, same user profile. All three servers are on the same network
segment in the datacenter. The new Talend server is Running Windows 2022
Datacenter, the old Talend server is running Windows Server 2016
Datacenter. I am using the same JDBC driver on both servers, and running
the same JVM on both servers. The connection is using the same set of JDBC
jobs on IBM i. Why would one connection be 2 orders of magnitude slower
than the other?
Does anyone have any ideas how to troubleshoot this? Or know of any tools
that I can use to determine what the issue might be? Or any
configurations that I might look at? I have already checked the driver
options, and they are identical.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.