Businesses collect enormous amounts of data every day. This data consists of information about orders, inventory, accounts payable, point-of-sale transactions, and customers. Businesses also acquire data, such as demographics and mailing lists, from both internal and outside sources. All of this data is stored in a data warehouse. The data warehouse, when used correctly, can help your company make better business decisions, leading to a competitive advantage in today's dynamic marketplace. The data warehouse that your company has implemented helps it to identify new and often overlooked business opportunities.
Queries issued against a data warehouse can often be resource intensive. Your company has installed DB2 Query Patroller to help manage the resource costs associated with those opportunity seeking queries that run against your data warehouse.
This book is intended for users of the data warehouse who submit and monitor queries. These users typically submit a query from an application and analyze the query's result set. In this environment, QueryEnabler is used to submit a query that is managed by the DB2 Query Patroller Server. QueryMonitor is used to monitor and manage those queries that you have submitted.
This book is organized in two parts. Use Table 1 to help you quickly navigate to the part of the book you are
interested in:
Table 1. How the DB2 Query Patroller User's Guide is Organized
| Part | Description |
|---|---|
| QueryEnabler. | This section provides information and procedures for using QueryEnabler to schedule and execute queries that are managed by the DB2 Query Patroller Server. Read this section if you are new to submitting queries in a DB2 Query Patroller environment. |
| QueryMonitor. | This section provides information and procedures for using QueryMonitor to monitor queries that are managed by the DB2 Query Patroller Server. Read this section if you would like detailed information on how to manage queries that you submitted using QueryEnabler. |