SYSCS_UTIL.SYSCS_KILL_OPERATION

The SYSCS_UTIL.SYSCS_KILL_OPERATION system procedure terminates an operation that is running on the server to which you are currently connected.

You can use the SYSCS_UTIL.SYSCS_GET_RUNNING_OPERATIONS system procedure. to find the UUID for an operation you want to kill.

Syntax

SYSCS_UTIL.SYSCS_KILL_OPERATION(operationId)

operationId

The UUID of the operation that you want to terminate.

This is the same UUID that is shown in the Spark console. You can use the SYSCS_UTIL.SYSCS_GET_RUNNING_OPERATIONS system procedure to discover the UUID for the operation.

Results

This procedure does not return a result.

Example

splice> call SYSCS_UTIL.SYSCS_GET_RUNNING_OPERATIONS();
UUID                                    |USER     |HOSTNAME         |SESSION    |SQL
-------------------------------------------------------------------------------------------------------------------------------
bf610dea-d33e-4304-bf2e-4f10e667aa98    |SPLICE   |localhost:1528   |2          |call SYSCS_UTIL.SYSCS_GET_RUNNING_OPERATIONS()
33567e3c-ef33-46dc-8d10-5ceb79348c2e    |SPLICE   |localhost:1528   |20         |insert into a select * from a

2 rows selected

splice> call SYSCS_UTIL.SYSCS_KILL_OPERATION('33567e3c-ef33-46dc-8d10-5ceb79348c2e');
Statement executed.