This book provides information on administering and operating DB2 Query Patroller. It also includes instructions for using the Tracker utility and guidelines for system configuration and troubleshooting.
This Guide is intended for those who need to administer, operate, and monitor the DB2 Query Patroller System. The audience generally consists of any person involved in day-to-day operations of DB2 Query Patroller. In many organizations, the system administrator or the database administrator is responsible for these tasks.
The book is organized in four parts. Use the table below to help you
quickly find the part of the book you are interested in:
Table 1. How the DB2 Query Patrol Administration Guide is Organized
| Part | Description |
|---|---|
| Part 1, DB2 Query Patroller Operations | This section provides an overview of DB2 Query Patroller and its components, and offers information and procedures for running and maintaining the system. |
| Part 2, The QueryAdministrator Utility | This section covers all aspects of using the QueryAdministrator utility. The QueryAdministrator utility enables the system administrator to manage the DB2 Query Patroller system parameters, create or delete profiles for DB2 Query Patroller authorized users, manage nodes and result destinations, and manage data sources. |
| Part 3, The Tracker Utility | The Tracker utility provides reports that display database usage history for queries that have been managed by the DB2 Query Patroller system. |
| Part 4, Appendixes | The appendixes for this guide include a section on troubleshooting the DB2 Query Patroller system and a section on DB2 Query Patroller error messages. |
This guide uses these highlighting conventions:
For additional information about DB2 Query Patroller refer to the following documents: