Dynamic System Tables › Using SQC Table to Cancel SQL Requests › Examples

Examples

Canceling Specific Requests by Accessor ID

Following is an example of canceling SQL requests for a specific accessor ID by issuing an SQL statement to delete the ACCESSOR_ID row from the SYSADM.SQL_STATUS_CURRENT table:

DELETE FROM SYSADM.SQL_STATUS_CURRENT
 WHERE ACCESSOR_ID = 'accessorid';

Canceling a Specific Transaction

Following is an example of canceling a specific transaction:

DELETE FROM SYSADM.SQL_STATUS_CURRENT
 WHERE LUW_BEG_REQ_NBR = 999999;

Canceling a Specific Plan

Following is an example of canceling SQL requests for a specific plan:

DELETE FROM SYSADM.SQL_STATUS_CURRENT
 WHERE PLAN_AUTH = authid
  AND PLAN_NAME = planname;

Canceling a Specific Job

Following is an example of canceling SQL requests for a specific job:

DELETE FROM SYSADM.SQL_STATUS_CURRENT
 WHERE JOB_NAME = 'jobname';

or, alternatively:

DELETE FROM SYSADM.SQL_STATUS_CURRENT
 WHERE RUN_UNIT = 99999;