Troubleshooting Guide

Chapter 6. Troubleshooting DB2 Query Patroller

The DB2 Query Patroller system is a way to control and process query requests from multiple client workstations or PCs. The server part of the system is made up of many components:

• Request server to service received requests.
• Cost analyzer to determine the relative cost to execute a query. This relative cost is used with the job scheduler component.
• Job scheduler to schedule the query-based information that includes the relative cost from the cost analyzer.
• Notifier to scan periodically for completed queries and then notify the originator of the query with the query status.
• Log monitor to track error information in a log file.

The agent part of the system is made up of two components:

• Node manager to execute any work assigned to it by the job scheduler.
• Executor to run the SQL statements and the system commands.

There are also other parts to the DB2 Query Patroller system:

• Command-line interface, enabling you to monitor and control the system by entering commands directly at the prompt, or from within shell scripts and languages such as PERL, awk, or REXX.
• Query Administrator, which provides an interface to manage nodes, result destinations, data sources, job queues, and to create or delete profiles for users.
• Tracker utility, to report on database usage history for queries managed by the system.
• Query Enabler, which allows queries submitted through an ODBC-compliant query tool to be managed by the system.
• Query Monitor, which provides an interface to monitor submitted queries.

For details about the DB2 Query Patroller system, see the DB2 Query Patroller Administration Guide manual.

For specifics on troubleshooting DB2 Query Patroller servers and clients, see the appendices in that manual.