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

qpstart

Stop Query Patroller

qpstop 

Note

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

db2dart: DB2 Database Analysis & Reporting Tool Command
Find the List of Active DB2 Databases
Find the DB2 Database License Status
How to Start DB2 System Tray in Windows
© 2017 ITsiti. All Rights Reserved
Powered by KEEM