Administration Guide

Troubleshooting Tracker

Tracker is an ODBC application that accesses the DB2 Query Patroller schema in DB2 in order to provide reports that display database usage history for queries that have been managed by DB2 Query Patroller.

Diagnostic information for Tracker can be obtained from four sources:

• the DB2 diagnostic log

• ODBC traces

• CLI traces

• DB2 traces

Common Tracker Problems

1. Tracker is unable to access DB2:

   • Ensure that the correct DB2 data source name, user name, and password have been specified.

2. Tracker does not display any data:

   • Ensure that the DB2 Query Patroller server has been configured to capture this information.

   • From QueryAdministrator, check that the Accounting option has been enabled.

   • Ensure that the date range specified in the Tracker application is set correctly to a time period when queries were in progress.

3. The data displayed by Tracker is not up-to-date:

   • Ensure the Tracker server on the DB2 Query Patroller server is scheduled to execute periodically. The Tracker server component may be executed interactively to generate up-to-date statistics.

[ DB2 List of Books | Search the DB2 Books ]