Configuring 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.

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

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.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms of Use | Feedback

Last updatedLast updated: Sep 20, 2011 12:32:59 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=matt&product=was-base-iseries&topic=tins_is_cfgsql
File name: tins_is_cfgsql.html