DB2 graphic QMF Version 8

Cancellation detail for a user

This report provides details on the queries that were canceled for a specific user, including the query name, SQL text, and reason for cancellation.

The following is an online example of the Cancellation Detail for a User report:

Table 61. Sample Cancellation Detail for a User Report
  RAAMR02T --------------------------- LINE 0000000 -- COLUMNS 031 079
  Command ===>                                        Scroll ===> PAGE
*************************** TOP OF REPORT  ***************************
  QMF CANCELLATION DETAILS    |
  FOR TSOID: DBPUSR           |
                              |
  QUERY     QUERY             |
  OWNER     NAME              |  DATE       TIME    REASON FOR CANCEL
  --------- ----------------  |  ---------- ------  -----------------
  DBPUSR    RUNAWAY           |  2099-10-24 06.17.48 QUERY ANALYZER CANCELED
  TSOP02    GOVDEMO           |  2099-10-24 06.15.59 ROW LIMIT EXCEEDED
  APP1XPL   TEST_APPQ         |  2099-10-24 06.18.31 ROW LIMIT EXCEEDED
  XPRT12D5  QUERY_LOC         |  2099-10-05 11.53.41 MONITOR CANCELED
 
********************* BOTTOM OF REPORT *******************************
 
 

Input variables

This report requires the following input variable:

TSOID
Enter the TSO ID for which you want to obtain cancellation detail information.

How to run this report online

You can invoke this report by selecting option 2 from the Object Manager Reports Selection Menu.

How to run this report in batch

Edit the sample JCL member RAAMR02J in QMFHPO.SRAASAMP. See the comments in this JCL member for instructions on what modifications are necessary before submitting the batch job.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004