DB2 Query Patroller

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.

Query Patroller is now included as part of the Performance Optimization Feature for DB2 Enterprise Edition. As part of DB2 9.5 Workload Management has been introduced to give database administrators more flexible and responsive control over their database workloads. Workload Management has been designed to work seamlessly with Query Patroller allowing you to smoothly transition to the new management capabilities of DB2 9.5. To learn more click here.