Re: Slow JDBC connection from remote server

[Mark Murphy <jmarkmurphy@xxxxxxxxx>]

As far as I can tell, the new server is noticeably faster than the old
server, except for the JDBC connection. I expect this because the new
server is a 4 socket 2.9Ghz Xeon with 64Gb of RAM while the old server is a
1 socket 2.0Ghz Xeon with 32Gb RAM. What I don't expect is the slowness of
the writes to IBM i

The new server is using a hotspot JVM vs the OpenJ9 JVM on the old server.
That shouldnt make that much difference should it? The JDBC driver is the
same on both. jtOpen 9.8.

On Thu, Jun 22, 2023 at 4:54 PM Richard Schoen <richard@xxxxxxxxxxxxxxxxx>
wrote:

> Make sure the new server is running at gigabit speed.
>
> Virus scanning/ransomware detection ?
>
> 32/64 bit Windows JVM ?
>
> Install something like DBeaver and run some queries.
>
> Just a few thoughts.
>
> Regards,
> Richard Schoen
> Web: http://www.richardschoen.net
> Email: richard@xxxxxxxxxxxxxxxxx
>
> ------------------------------
>
> message: 3
> date: Thu, 22 Jun 2023 15:25:21 -0400
> from: Mark Murphy <jmarkmurphy@xxxxxxxxx>
> subject: Slow JDBC connection from remote server
>
> IBM i v7.2
>
> 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.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.