topic Re: Slow writes to DB2 for i when running in Windows 2022 in Talend Studio

Slow writes to DB2 for i when running in Windows 2022

MarkM1 — Mon, 10 Jul 2023 13:50:13 GMT

Our infrastructure guy set up two VM's one with Windows 2016, the other with Windows 2022. I installed the same software on both: TOS 7.3, Eclipse Adoptium Java 11. The same Talend model on both systems. This is what happened.

Windows Server 2016

Windows Server 2022

As you can see, Windows 2016 is more than 100 times faster than Windows 2022.

Any idea why this might be? Watching the run, the input is fast in both cases. Is there a known problem with Windows 2022?

Re: Slow writes to DB2 for i when running in Windows 2022

MarkM1 — Tue, 11 Jul 2023 13:52:28 GMT

We have set up another test VM with Windows 2019, and the result was the same as the Windows 2022 test, and I also ran using Java 17 and TOS v8.0 on Windows 2022. Still have the issue.

Re: Slow writes to DB2 for i when running in Windows 2022

tperroin — Mon, 04 Sep 2023 15:37:18 GMT

Hello,

We had the same problem with Talend Cloud Edition version 2022-11. Talend and DB2 for i were always slow. But migrating to a Windows Server 2016, 2019 or 2022 was even worse.

In the 2023-04 release, Talend made a fix to the connection parameters. By default, the `Statement.RETURN_GENERATED_KEYS` parameter was active and caused the slow writes. Now that it is disabled by default, the performance is back and even better than before.

I suggest you to migrate to the latest version or at least the 2023-04 release. Sadly, I don't know if it available in the Open Source Studio.

Hope this helps you.

Re: Slow writes to DB2 for i when running in Windows 2022

MarkM1 — Mon, 11 Sep 2023 17:28:51 GMT

I tried upgrading to TOS 8.0, but that made no difference. For us, Windows 2016 is ok, but 2019 and 2022 are 100 times slower. Maybe we will have to wait for the next update of 8.x.