Set SQL server jobs
If you are using the IBM Developer Kit for Java JDBC driver to access the OS/400 database from your applications, you may need to change the maximum number of jobs allowed for the SQL server jobs. Each JDBC connection object requires an SQL server job. Generally, it is easiest 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. For example:
CHGPJE SBSD(QSYSWRK) PGM(QSQSRVR) MAXJOBS(*NOMAX)
If *NOMAX is not an appropriate setting for your iSeries environment, specify an integer value for the MAXJOBS parameter which will allow your applications to have enough SQL server jobs to handle the maximum number of JDBC connections required at any given time by your applications.
This message is displayed when the maximum number of jobs is successfully changed:
Program QSQSRVR found in library QSYS. Active subsystem description QSYSWRK in QSYS changed.
