Choose either of two methods to change the maximum number of SQL
server jobs allowed. Each Java Database Connector (JDBC) connection object
requires one SQL server job.
Before you begin
If you are using the JDBC driver in the IBM Developer Kit for Java
to access the i5/OS database from your applications, you might
need to change the maximum number of jobs allowed.
About this task
This procedure describes two methods for setting the number of SQL
server jobs allowed to an adequate amount to handle the workload.
Procedure
- Set the maximum number of jobs to *NOMAX.
Generally, it is easier to account for the number of jobs you need
by setting the maximum number of jobs to *NOMAX. Use
the Change Prestart Job Entry (CHGPJE) command to change
the prestart job entry for the SQL server jobs.
CHGPJE SBSD(QSYSWRK) PGM(QSQSRVR) MAXJOBS(*NOMAX)
- Set MAXJOBS to a large enough integer value for your applications
to handle SQL server jobs.
If *NOMAX is not an appropriate setting
for your iSeries environment, specify a large enough integer value for the
MAXJOBS parameter so that your applications have enough SQL server jobs to
handle the maximum number of JDBC connections required at any given time by
your applications.
Results
After the maximum number of jobs is successfully changed, the following
message is displayed:
Program QSQSRVR found in library QSYS.
Active subsystem description QSYSWRK in QSYS changed.