Conventions
Welcome to DB2 Universal Database!
Conventions
System Overview
DB2 Query Patroller Components
DB2 Query Patroller Server
DB2 Query Patroller Agent
Command Line Interface
QueryAdministrator
Tracker
QueryEnabler
QueryMonitor
DB2 Query Patroller Control Tables
How Components Communicate
How Jobs are Processed
Getting Started
The iwm Administrative User Account
Updating the dqpnodes.cfg File
Enabling Query Management
Starting and Stopping DB2 Query Patroller
Starting and Stopping DB2 Query Patroller as a Service on Windows
Using QueryAdminstrator to Administer DB2 Query Patroller
Using QueryAdministrator
Starting QueryAdministrator
Stopping QueryAdministrator
Displaying Columns
Resizing Columns
User Administration
Adding Users
How User Profiles are Resolved
Creating a User Profile
Editing a User or Group Profile
Removing a User or Group Profile
Querying for the Effective User Profile
Data Source Administration
Listing Data Sources
Editing a Data Source Definition
Node Administration
Listing All Nodes
Changing the Node Status
Result Destination Administration
Result Destinations
Listing Result Destinations
Creating a Result Destination
Editing a Result Destination
Removing a Result Destination
Job Queue Administration
Viewing Job Queues
Creating a Job Queue
Editing a Job Queue
Removing a Job Queue
System Administration
Listing System Parameters
Editing System Parameters
DB2 Query Patroller E-Mail Notification
E-mail Notification on UNIX
E-Mail Message Formatting
E-mail Notification on Windows
Configuring E-mail Notification on Windows
DB2 Query Patroller Profile Variables
DB2 Profile Variables
Server Profile Variables
Client Profile Variables
Windows Specific DB2 Profile Variables
Performance Tuning
Profiling
Estimating and Monitoring
Modifications
Configuring the Data Warehouse
Configuring a DB2 Query Patroller Client
Managing Jobs
Releasing and Canceling Jobs
Controlling Job Flow and Execution
Exit Analysis
Replacing the DB2 Query Patroller Database
Using the Command Line Interface to Administer DB2 Query Patroller
Command Line Interface Environment
Submit Command (iwm_submit)
Control Command (iwm_cmd)
Common iwm_cmd Parameters
Monitoring Jobs
Controlling Jobs
Monitoring and Controlling Nodes
Listing and Controlling Data Sources
Listing and Controlling System Parameters
Monitoring the DB2 Query Patroller System
The Tracker Tool
Creating Tracker Data on the Database Server (iwm_tracker)
Tracker Reports
Using Tracker
Job Accounting
Job Accounting Table Columns
Log Monitoring
Running the Log Monitor
Log Monitor Configuration File
Example Configuration File
Log File
INTERVAL Command
LOGFILE Command
MAILTO Command
INCLUDE and EXCLUDE Commands
Appendix A. Troubleshooting the DB2 Query Patroller Server
Distinguishing Between DB2 and DB2 Query Patroller Failures
syserr.log
DB2 Diagnostic Log
Processes
DB2 Query Patroller Server
DB2 Query Patroller Agent
Process Failures
Generating a Trace File
Common Server Problems
Appendix B. Troubleshooting DB2 Query Patroller Clients
Troubleshooting QueryEnabler
Common QueryEnabler Problems
Troubleshooting QueryMonitor and QueryAdministrator
Common QueryMonitor and QueryAdministrator Problems
Troubleshooting Tracker
Common Tracker Problems
Appendix C. Using the DB2 Library
DB2 PDF Files and Printed Books
DB2 Information
Printing the PDF Books
Ordering the Printed Books
DB2 Online Documentation
Accessing Online Help
Viewing Information Online
Using DB2 Wizards
Setting Up a Document Server
Searching Information Online
Appendix D. Notices
Trademarks