If a user submits a query to DB2 Query Patroller and DB2 Query Patroller estimates the job's cost to be greater than the user's limit as defined in the user's profile, then the job receives a hold status. In order for a job with a hold status to run, the system administrator or operator must release the job using QueryMonitor or the command line interface. While a job is in the DB2 Query Patroller system, the system administrator, operator, or the job's owner may cancel the job. A list of the jobs with a hold status or those jobs with some other status can be obtained through the QueryMonitor or command line interface. See the DB2 Query Patroller User's Guide for more information about viewing a job's status using the QueryMonitor tool. For more information about using the command line interface, see Using the Command Line Interface to Administer DB2 Query Patroller.
If a user's jobs are regularly put on hold you may want to grant authority to submit more expensive jobs. You can grant a user or group this authority by adjusting the User Threshold parameter in the user or group profile. This task can be performed using the QueryAdministrator tool. For more information, see User Administration.