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.