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 IBM i®.

On the IBM i 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 IBM i 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 IBM i 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 tasks
Tuning the application serving environment
Related reference
IBM i5/OS Information Center: Monitor and tune database performance
Related information
i5/OS Performance Management Resource Library
Reference topic    

Terms of Use | Feedback

Last updated: Oct 21, 2010 3:36:59 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=compass&product=was-express-iseries&topic=rdat_tuneDB2i
File name: rdat_tuneDB2i.html