Step 1.
Log on to the DB2 Query Patroller Server with the iwm user account that was created before or during the installation.
Step 2.
Start the DB2 Query Patroller service by entering the dqpstart command. You should receive output that is similar to the following:
DB29997I "DB2 Query Patroller" started successfully.
 |
You can also start the DB2 Query Patroller service directly using the
Services panel, which can be launched from the Control
Panel folder.
|
Step 3.
Submit a query that will be captured by the DB2 Query Patroller Server by entering the following command:
iwm_submit -S "select count(*) from sysibm.systables"
You should receive output that is similar to the following:
DB2 Query Patroller Version "7.1" (c) Copyright International Business Machines Corp. 1998, 2000. All rights reserved. DB2-09973-I Job "1" queued. (Cost = "1").
This verifies that the query was passed to the DB2 Query Patroller Server. Allow a few moments for the job to process.
Step 4.
Check the status of the query you just submitted by entering the following command:
iwm_cmd
If the job has completed successfully, you should receive output that is similar to the following:
DB2 Query Patroller Version "7.1" (c) Copyright International Business Machines Corp. 1998, 2000. All rights reserved. Job Status (user "iwm") --- ---------------------------------------------------------------------- 1 Done at "2000-02-07 15:16:03.015001" : "1" rows in "iwm.JOB0000001_RES
If the job is still in progress, you would receive output such as:
DB2 Query Patroller Version "7.1" (c) Copyright International Business Machines Corp. 1998, 2000. All rights reserved. Job Status (user "iwm") --- ------------------------ 1 Queued: Priority is "500"
Step 5.
Stop the DB2 Query Patroller service by entering the dqpstop command. You should receive the following output:
DB29998I "DB2 Query Patroller" stopped successfully.
|
|
You can also stop the DB2 Query Patroller service directly using the
Services panel, which can be launched from the Control
Panel folder.
|