+

Search Tips   |   Advanced Search

DB2 Universal Database performance tips

We can adjust the 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 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 we 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:

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


Related tasks

  • Tune the application serving environment


    IBM i Information Center: Monitor and tune database performance


    Related information:

    IBM i Performance Management Resource Library Reference topic