Congratulations on purchasing DB2 Query Patroller Version 7. You have just taken the first step to a better understanding of the resource costs associated with your users' queries. This version of DB2 Query Patroller adds support for HP-UX, NUMA-Q/PTX, and Windows 2000, as well as continuing to support AIX, the Solaris Operating Environment, and Windows NT.

You can use DB2 Query Patroller to provide query and resource management for decision support systems (DSS). The DB2 Query Patroller tools support highly scalable data warehouses, data marts, and other data mining intensive database structures. What's more, these tools are written in Java and can therefore be run on any platform.

DB2 Query Patroller traps queries from enabled DB2 clients, analyzes the queries, and then dynamically prioritizes and schedules them for processing. If you are using DB2 Enterprise - Extended Edition, DB2 Query Patroller can distribute its workload across different database partition servers using a DB2 Query Patroller Agent. DB2 Query Patroller also provides tools that produce detailed system utilization and database usage reports.

This book will take you through the planning, installation, potential migration, and setup of a DB2 Query Patroller Server on a server that is running AIX, HP-UX, NUMA-Q/PTX, the Solaris Operating Environment, Windows NT, or Windows 2000.

The DB2 Query Patroller Server captures queries from DB2 clients that are installed with a Query Patroller Client. A DB2 Query Patroller Client is available for installation as a component of a DB2 Administration Client on Windows NT and Windows 2000.

On UNIX, the DB2 Query Patroller Client is available for installation as a product from the DB2 Query Patroller CD-ROM. You must install this client on a previously installed DB2 client.

For information on how to install a DB2 client, refer to the Installation and Configuration Supplement.