SYSCS_UTIL.SYSCS_GET_RUNNING_OPERATIONS

The SYSCS_UTIL.SYSCS_GET_RUNNING_OPERATIONS system procedure displays a list of the operations running on the server to which you are currently connected.

You can use this procedure to find the UUID for an operation, which you can then use for purposes such as terminating an operation with the SYSCS_UTIL.SYSCS_KILL_OPERATION system procedure.

Syntax

SYSCS_UTIL.SYSCS_GET_RUNNING_OPERATIONS();

Results

The displayed results of calling SYSCS_UTIL.SYSCS_GET_RUNNING_OPERATIONS include these values:

Value Description
UUID The operation identifier. This is the same identifier that is shown in the Spark console.
USER The name of the database user.
HOSTNAME The host on which the server is running.
SESSION The session ID.
SQL The SQL statement that is running.

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.