(iSeries)

Configure SQL jobs on IBM i

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.

If we are using the JDBC driver in the IBM Developer Kit for Java to access the IBM i database from the applications, we might need to change the maximum number of jobs allowed.

This procedure describes two methods for setting the number of SQL server jobs allowed to an adequate amount to handle the workload.

Tasks

• Set the maximum number of jobs to *NOMAX.

  Generally, it is easier to account for the number of jobs we 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 the applications to handle SQL server jobs.

  If *NOMAX is not an appropriate setting for our IBM i environment, specify a large enough integer value for the MAXJOBS parameter so that the applications have enough SQL server jobs to handle the maximum number of JDBC connections required at any given time by the applications.

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 Configure TCP/IP on IBM i to continue the installation.

Configure the product after installation on IBM i