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

Activate & Deactivate DB2 Database
SQL1116N: Connection to DB2 Failed because Backup Pending
Get the Lists and Information on DB2 Tablespace
Find the DB2 Database License Status
© 2017 ITsiti. All Rights Reserved
Powered by KEEM