Slow connection time using JDBC on iSeries

HCL Domino Domino Forum
1

I have written an agent in Java using JDBC using a third party JDBC Driver to SQL Server. My server is 6.5.3 and running on iSeries.

When I run the agent on my client, it takes about one second (1181 ms) to execute the entire agent.

When I schedule the agent to run on the Domino server (or run it in a QueryOpenAgent) the agent takes about 11 seconds. It’s connecting to the same database as that that I connect to with my client.

I have narrowed down the expensive statements to the following:

2.9 seconds: Class.forName(“com.inet.tds.TdsDriver”).newInstance();

7.7 seconds: Connection connection = DriverManager.getConnection(url,login,password);

The driver is packaged with my agent. Is there anything I can do to speed up these statements from the application side? Is this more than likely a network issue?

Thanks,

Michael Dabisch

2

Subject: Slow connection time using JDBC on iSeries

Hello Michael,I have the same problem with a db2 400 connection.

Did you find a solution?

3

Subject: Slow connection time using JDBC on iSeries

Hi Michael,

I have an agent connecting to DB2 on iSeries, in W2k It works fine, I moved it to a Domino on iSeries and it does not work. Do you know abot any additional configuartiopn I need to do on the iseries.

Thanks in adv… !