You can easily adjust your system QSQSRVR prestart job settings
to optimize the process of acquiring connections from DB2 Universal Database
for i5/OS.
On the i5/OS platform, QSQSRVR jobs process Java Database Connectivity
(JDBC) tasks. By default, five QSQSRVR jobs are initially active. When fewer
than two QSQSRVR jobs are unused, the i5/OS system creates two more jobs.
If you increase the active job values, an application that establishes a large
number of database connections over a short period of time might create connections
more quickly. Increase the values for the initial number of jobs, threshold,
and additional number of jobs by running this command on an i5/OS command
line:
CHGPJE SBSD(QSYS/QSYSWRK) PGM(QSYS/QSQSRVR)
Do
not start more QSQSRVR jobs than your application requires. Active QSQSRVR
jobs require some overhead, even if these jobs are not used.