  Database administrators are all too aware of the special obstacles encountered in managing data warehouses and very-large-database (VLDB) environments: - Too many simultaneous queries
- Expensive concurrent queries
- Runaway queries
- No way to assign priorities to different jobs
- No control over submitted queries
- Analysis of database and resource usage very difficult
Which can result in: - Erratic query response time
- Unsatisfied users
- Frustrated systems people
- Unnecessary expense
DB2 Query Patroller’s features include: - Predictive governing which regulates data access before entering the system
- Priority queuing which allows the DBA to assign different priorities to different users / groups
- Job queuing functionality to make queries run more efficiently
- Query monitoring which provides real time viewing and access to executing queries
- Historical analysis which allows administrators to view, over a specified period of time, what data is being accessed and by who, as well as data that is not being accessed
DB2 Query Patroller is a powerful query management system that you can use to proactively and dynamically control the flow of queries against your DB2 database in the following key ways: - Define separate query classes for queries of different sizes to better share system resources among queries and to prevent smaller queries from getting stuck behind larger ones
- Give queries submitted by certain users high priority so that these queries run sooner
- Automatically put large queries on hold so that they can be canceled or scheduled to run during off-peak hours
- Track and cancel runaway queries
The features of DB2 Query Patroller allow you to regulate your database’s query workload so that small queries and high-priority queries can run promptly and your system resources are used efficiently In addition, information about completed queries can be collected and analyzed to determine trends across queries, heavy users, and frequently used tables and indexes. | 
