REMOVE STATEMENT LOCKS

The REMOVE STATEMENT LOCKS utility function clears all orphaned locks that block file cleanup and prevent operations on locked objects within the system.

To remove specific locks, see REMOVE LOCK

Read more about locks in Concurrency and Locks.

Syntax

SELECT REMOVE_STATEMENT_LOCK(<stmt_id> [, <ignore_stmt_exists> ])

Example

SELECT REMOVE_STATEMENT_LOCKS (0);

Permissions

This utility function requires a SUPERUSER permission on the database level.