Administration Guide

Common Server Problems

1. The DB2 Query Patroller server fails to start:

   • Make sure DB2 is started.

   • Make sure that the DB2 Query Patroller TCP/IP port is not being used by another process.

   • Check environment variables to ensure that they are set correctly.

   • Check the syserr.log file for specific process errors.

2. The DB2 Query Patroller agent fails to start:

   • Ensure that the DB2 Query Patroller agent and DB2 Query Patroller server communications configuration specify the same TCP/IP port.

   • Check the setting of the DB2 profile variable IWM_Server to ensure that the correct TCP host name for the DB2 Query Patroller server is specified.

   • Ensure that the TCP/IP port is not in use on the DB2 Query Patroller Agent system.

3. A job is in the queue but will not run:

   • Check the DB2 Query Patroller error log to make sure there have been no DB2 Query Patroller process failures.

   • Check the DB2 Query Patroller system configurations to ensure that they are set correctly.

   • Restart the DB2 Query Patroller server.

[ DB2 List of Books | Search the DB2 Books ]