DB2 Query Patroller Installation Guide

Configuring DB2 Query Patroller Clients

The Query Patroller clients require the following:

• Each user must have an account on the database server system.

• The client machines must have a IBM DB2 ODBC driver installed and configured to the target database.

The QueryAdministrator, QueryMonitor, and Tracker do not require configuration. In the login window, simply provide the user ID, password, and the database alias for the target database.

QueryEnabler

Complete the following procedure to configure QueryEnabler:

1. From the Start menu, select Settings > Control Panel.

2. Double-click the 32-bit ODBC icon. The ODBC Data Source Administrator window displays.

3. Select the System DSN tab.

4. Click on Add.

5. Double-click on IBM DB2 Query Patroller QueryEnabler Driver in the list of drivers. The DB2 Query Patroller ODBC Driver Setup window displays.

6. Enter information into the following fields:

   • Data Source Name: Enter a meaningful name. This is the name of the new data source.

   • Description: Enter a description.

   • Final Data Source: Select an existing data source from the pull-down list. This must be a DB2 datasource name.

   • Click on OK to complete the configuration.

   • Click on OK to close the ODBC Data Source Administrator screen.

   • Close the Control Panel.

Testing QueryEnabler Installation

Complete the following procedure to test the QueryEnabler:

1. Run your query application.

2. Open a connection using the QueryEnabler data source.

3. Submit a query.

   Either the Schedule Query screen displays if the query has not been submitted before or the Result Set window opens if a matching query exists in the DB2 Query Patroller job table.

[ DB2 List of Books | Search the DB2 Books ]