How to Start & Stop Query Patroller in DB2

Share this article :

The Query Patroller is a tool developed for query management system. With this tool, user can proactively and dynamically control the flow of queries in the DB2 database. The functions allow users to regulate the database query workloads in which the low and high priority queries can be run promptly.

Users can collect the completed queries and analyze accordingly to rectify the trends on the following,

• users usage
• most access tables / indexes
• low / high volume queries

As result, the system resources are been used efficiently.

Before the Query Patroller can be started, you need to ensure the DB2 database is started and the parameter dyn_query_mgmt is set to ENABLE.

Start Query Patroller


Stop Query Patroller



As of DB2 Version 10.1 for Linux, UNIX, and Windows – The Query Patroller is discontinued and you must use the DB2® workload manager instead as your workload management solution. Refer to IBM websitefor details.

Related posts

Find Installed Instances in DB2
Find the List of Active DB2 Databases
Get the Lists and Information on DB2 Tablespace
Enable & Disable DB2 Instance Auto Start
© 2017 ITsiti. All Rights Reserved
Powered by KEEM