Improve performance of JDBC connectivity
2 posters
Page 1 of 1
Improve performance of JDBC connectivity
Users are complaining that their PC-based application, which
connects to the System i using JDBC, has gotten progressively slower when initially
connecting to the System i. The number of users for this application has been
increasing recently. The PC and Network support departments report no problems.
How can the time required for the users' JDBC jobs to start be decreased?
connects to the System i using JDBC, has gotten progressively slower when initially
connecting to the System i. The number of users for this application has been
increasing recently. The PC and Network support departments report no problems.
How can the time required for the users' JDBC jobs to start be decreased?
Re: Improve performance of JDBC connectivity
Increase the "Initial number of jobs" and the "Additional number of jobs" for the QZDASOINIT prestart job.
QZDASOINIT is the jobname for the database SQL server jobs on the System i. These jobs are used to serve SQL to JDBC and ODBC client applications. The jobs run the default QUSRWRK subsystem. iSeries Nav jobs also use this job name when running a query through the SQL window in Operations Navigator.
QZDASOINIT is the jobname for the database SQL server jobs on the System i. These jobs are used to serve SQL to JDBC and ODBC client applications. The jobs run the default QUSRWRK subsystem. iSeries Nav jobs also use this job name when running a query through the SQL window in Operations Navigator.
sivakumar- Posts : 174
Join date : 2009-07-27
Age : 37
Location : Chennai
Similar topics
» How to improve the performance of HTTP server
» Improve the performance of the RPG program - Tip1
» Improve the performance of the RPG program – Tip2
» Improve the performance of the RPG program - Tip1
» Improve the performance of the RPG program – Tip2
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|