Administration Guide

Troubleshooting QueryMonitor and QueryAdministrator

QueryMonitor and QueryAdministrator are Java applications that access DB2 using JDBC. Diagnostic information can be obtained from four sources:

• the DB2 diagnostic log

• ODBC traces

• CLI traces

• DB2 traces

Typically those trace tools are launched using a Java Virtual Machine (JVM) that does not have a console (JREW.EXE). These trace tools may also be run in a JVM that has a console (JRE.EXE), in which case DB2 Query Patroller will print information to the console. You can use that information to help identify the cause of a problem.

Common QueryMonitor and QueryAdministrator Problems

1. The tool is unable to connect to DB2:

   • Ensure that the DB2 data source name is used in the connect dialog.

   • Ensure that you have supplied the correct user name and password.

2. The application stops responding:

   • Close and restart the application. If the problem persists, attempt to run the application from a JVM with a console to obtain additional diagnostic information.

[ DB2 List of Books | Search the DB2 Books ]