IBM DB2 Query Patroller 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 DB2 Query Patroller profile 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 DQP_SERVER to ensure that the correct TCP host name for the DB2 Query Patroller server is specified.
   • Ensure that this 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.
4. DB2 Query Patroller Service on Windows fails to start:
   • Check to make sure DB2 is started.
   • Check that the user account associated with the service has the correct system access rights and a valid password.
   • Check all DB2 Query Patroller profile variables to see if they are set correctly.
   • Make sure that there are no orphan DB2 Query Patroller processes prior to starting the system.
   • Make sure a valid license key has been registered.
5. Sending of e-mail notification on Windows fails:
   • Make sure that a MAPI profile for the user account associated with the DB2 Query Patroller service has been created.
   • Ensure that all DQP_MAPI environment variables have been properly set.
   • Make sure the account associated with the DB2 Query Patroller service has the necessary access to the mail provider.
   • If the mail provider requires a password to logon to the mail service, set the DQP_MAPI_PASSWORD to this value and re-start the service.
   • If the MAPI service provider requires the sender of the mail to be a user account different from the user account associated with the DB2 Query Patroller service, try to use the DQP_MAIL_ACCOUNT environment variable.
   • Check the syserr.log for DQP_MAIL.EXE specific errors.