DB2/400 performance problems on Windows

DB2/400 performance problems on windows

When installing Comflow on a 2019 or 2022 Windows server, you can get a significant decrease in SQL performance against DB2/400. This is due to some control of the network in windows that needs to be bypassed. With JT400 version 11.1 this is solved in the db-driver together with an additional parameter in the DB-URL, "tcp no delay=true". See example in sitedef below:

				<Service name="M3SCT" type="jdbcpool" class="" port="">
					<Parameters>
						<parameter name="driver" value="com.ibm.as400.access.AS400JDBCDriver" />
						<parameter name="url" value="jdbc:as400://server.domain.net; tcp no delay=true " />
						<parameter name="user" value="USER" />
						<parameter name="password" value="PASSWORD" />
						<parameter name="validationQuery" value="select 1 from sysibm.sysdummy1"/>
						<parameter name="charset" value="UCS-2" />
						<parameter name="useCaseingOnTable" value="true" />
					</Parameters>
				</Service>

Comflow 2.22.16 and 2.24 are both updated with JT400 version 11.1. If you are running another version of Comflow, you have to manually install JT400 version 11.1 or later.