Dynamic System Tables › Using SQC Table to Cancel SQL Requests

Using SQC Table to Cancel SQL Requests

The SYSADM.SQL_STATUS_CURRENT (SQC) Dynamic System Table describes the current status of all active SQL transactions. Detailed information is provided about all currently executing SQL transactions including the following:

• Processing steps (for example, joins, unions, sorts)
• What tables and indexes are being accessed
• Number of rows read, and so on

If you identify particular SQL activities as "runaway" tasks, you can cancel them by "deleting" the appropriate rows from the SQC table. Any selection criteria can be used. While it is convenient, care must be taken to avoid canceling more work than you intend, and proper security provided to restrict access to the SQC table.

For more information, see Processing Details.