DB2 Query Patroller

DB2 Query Patroller is a powerful query management system that can control the flow of queries against your DB2 database.

It allows 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.

• Collects and analyzes information about completed queries to determine trends across queries, heavy users, and frequently used tables and indexes
• Defines 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, and automatically puts large queries on hold so that they can be canceled or scheduled to run during off-peak hours
• Gives queries submitted by certain users high priority so that these queries run sooner
• Tracks and cancels runaway queries
• Administrators can use Query Patroller to set resource usage policies at the system level and at the user level, actively monitor and manage system usage by canceling or rescheduling queries that could impact database performance, and generate reports that assist in identifying trends in database usage such as which objects are being accessed, and which individuals or groups of users are the biggest contributors to the workload
• Query submitters can use Query Patroller to monitor the queries they have submitted, store query results for future retrieval and reuse, effectively eliminating the need for repetitive query submission, and set a variety of preferences to customize their query submissions, such as whether to receive e-mail notification when a query completes
• DB2 Query Patroller is available separately or as part of DB2 Data Warehouse Enterprise Edition

View features and benefits

Products

View all additional offerings

• New chat with the lab
• DB2 UDB: The Autonomic Computing Advantage