LucidDbSysRoot KILL STATEMENT

Syntax

CALL SYS_ROOT.KILL_STATEMENT( stmt_id [, cancel_only ] )

Purpose

Cancels a LucidDB SQL statement, aborting its execution. If cancel_only is false (the default), also destroys the statement, first waiting for it to respond to the cancel request and finish executing. If cancel_only is true, returns immediately (not waiting for the abort to complete).

Parameters

• stmt_id: statement ID [BIGINT], which can be obtained via view DBA_SQL_STATEMENTS.
• cancel_only: [BOOLEAN] true to just abort; false (default) to destroy statement, releasing its resources

Example

-- list running statements to find the one tying up resources
SELECT stmt_id, sql_text FROM sys_root.dba_sql_statements;
+-------------+---------------------------------------------------------------+
| STMT_ID     |                           SQL_TEXT                            |
+-------------+---------------------------------------------------------------+
| 5           | select * from s.bench100 b1, s.bench100 b2 order by 1         |
| 8           | select session_id, sql_text from sys_root.dba_sql_statements  |
+-------------+---------------------------------------------------------------+

-- give 'em the boot
CALL sys_root.kill_statement(5);