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 IBM i 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 IBM i 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.
What to do next
Go to Configuring TCP/IP on IBM i to continue the installation.