You can control the number of jobs, where they run, and the load put on the database by altering the data source, job queue, and system parameters. See the following sections:
If your system is not processing jobs fast enough, you may want to adjust the value of the DQP_INTERVAL profile variable. Decreasing this value will decrease the amount of time between searches for work by the DB2 Query Patroller system. For more information, see DB2 Profile Variables.
To view statistics and reports for jobs that have run against your data source, use the Tracker tool. For more information, see The Tracker Tool. For information on performance tuning, see Performance Tuning.