Administration Guide

Troubleshooting QueryEnabler

The QueryEnabler is both an ODBC driver and an ODBC application. When trapping user queries, it acts as an ODBC application. When performing database access to DB2, it acts as an ODBC driver.

Whenever a problem occurs, you should check the following:

• the DB2 server is started

• the application can connect to the DB2 server directly using the DB2 cataloged names

• the QueryEnabler data source name is configured correctly to use the correct DB2 data source

• the application is using the correct QueryEnabler data source name

In order to help identify problems, IBM support representatives may employ the following tracing mechanisms collectively or separately:

• ODBC trace via the ODBC Data Source Administrator

• DB2 CLI trace

• DB2 trace

• DB2 QueryEnabler trace

The first three trace facilities are described in the Troubleshooting Guide. Refer to this document for detailed instructions.

DB2 QueryEnabler trace is enabled by editing the INI file DB2IWM.INI located in the Windows system directory and changing the value of LOG from FALSE to TRUE.

After this modification, the application accessing QueryEnabler should be restarted and the problem under investigation should be repeated to generate a diagnostic log called DB2IWM.LOG located in the root of the C partition, i.e. C:\DB2IWM.LOG.

This file will contain all ODBC function calls accessed in QueryEnabler by the application. QueryEnabler will continue to log information to this file until the LOG parameter in the DB2IWM.INI file is reset to FALSE. Ensure that there is sufficient free disk space on the C partition to support this file.

Common QueryEnabler Problems

1. The application is unable to connect to DB2:

   • Verify that the application is able to connect to DB2 using the DB2 data source names. If this fails, refer to the Troubleshooting Guide for information on how to resolve a connectivity problem.

   • Verify that the QueryEnabler data source is configured to use the correct DB2 data source.

   • Ensure that the user account and user passwords are correct.

2. The application is unable to access the QueryEnabler query submission dialogs:

   • Ensure the application is using the correct QueryEnabler data source name.

3. The QueryEnabler dialogs appear unexpectedly:

   • QueryEnabler will trap all DB2 queries through the ODBC interface except for queries accessing the DB2 system catalogs. Some applications will query DB2 in support of the application. These queries supplement the main user query. QueryEnabler cannot distinguish between the main user query and the supplemental query. In this event, select the Submit and Wait button to execute these queries. This allows time for the result set to be constructed and unwanted QueryEnabler dialogs do not appear.

4. The query application is unable to submit a query to the DB2 Query Patroller server using QueryEnabler:

   • Ensure the DB2 Query Patroller server stored procedures have been installed on the DB2 server.

   • Ensure the user has been granted the proper DB2 access to the stored procedures.

5. The application has submitted a query to the DB2 Query Patroller server but the query is not being executed:

   • Ensure that the DB2 Query Patroller server is running correctly. It may be necessary to restart the DB2 Query Patroller server.

   • Use QueryMonitor to inspect the details of the Job. The job may be held because the query exceeded user thresholds. An DB2 Query Patroller administrator or operator must be contacted to release this job.

   • The job may be in the queue state because system resources have exceeded configured limitations. Under these conditions, the query will execute once the system resources fall within acceptable limits as configured by the DB2 Query Patroller administrator.

[ DB2 List of Books | Search the DB2 Books ]