DB2 Universal Database performance tips

Operating Systems: i5/OS
Â Â Â Â Â Â Â Â Â Â Â Â Â Personalize the table of contents and search results

This topic applies only on the i5/OS operating system.

DB2 Universal Database performance tips

You can easily adjust your system QSQSRVR prestart job settings to optimize the process of acquiring connections from DB2 Universal Database for i5/OS. On the i5/OS platform, QSQSRVR jobs process Java Database Connectivity (JDBC) tasks. By default, five QSQSRVR jobs are initially active. When fewer than two QSQSRVR jobs are unused, the i5/OS system creates two more jobs. If you increase the active job values, an application that establishes a large number of database connections over a short period of time might create connections more quickly. Increase the values for the initial number of jobs, threshold, and additional number of jobs by running this command on an i5/OS command line:

CHGPJE SBSD(QSYS/QSYSWRK) PGM(QSYS/QSQSRVR)

Do not start more QSQSRVR jobs than your application requires. Active QSQSRVR jobs require some overhead, even if these jobs are not used.

Related information

URL takes you to the "Monitor and tune database performance" section in the Database topic of the IBM iSeries Information Center. The content addresses DB2 Universal Database for i5/OS. If you use a different database, refer to that vendor documentation.">IBM i5/OS Information Center: Monitor and tune database performance
URL takes you to the i5/OS Performance Management Resource Library page, which contains links to several editions of the Performance Capabilities Reference. Consult chapter 4 of this reference document.">i5/OS Performance Management Resource Library

Reference topic

Â Â Â