Troubleshooting Guide
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 services 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 periodically scan 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
using commands entered 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, refer to the DB2 Query Patroller Administration Guide manual.
For specifics on troubleshooting DB2 Query Patroller servers and clients,
refer to the appendices in that manual.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]