Administration Guide

Creating Tracker Data on the Database Server

The information displayed by Tracker is gathered by DB2 Query Patroller running on your database server. DB2 Query Patroller collects job accounting data, which is then analyzed by iwm_tracker. The iwm_tracker program, the back-end parser for DB2 Query Patroller, analyzes data for successfully completed job runs. Each time iwm_tracker runs, it examines any job accounting entries added since its last run.

Before running Tracker for the first time, you must set up iwm_tracker as follows:

1. In DB2 Query Patroller, turn on job accounting data collection. Use the QueryAdministrator utility, or the command line interface to set the Accounting Status system parameter to active.

2. Determine when the iwm_tracker program runs. Choose a time period that is appropriate for the query volume and usage pattern of your database. You might want to run iwm_tracker at night or on the weekend, when the database load is light.

3. Run iwm_tracker at least once to ensure that data is available the first time you run the Tracker utility.

[ DB2 List of Books | Search the DB2 Books ]