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:
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 ******************************* |
This report requires the following input variable:
You can invoke this report by selecting option 2 from the Object Manager Reports Selection Menu.
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.