The syntax for lct_admin abort is:
lct_admin("abort", {process_id [, database_id]})
Before you can abort a transaction, you must first determine its ID. See “Getting the process ID for the oldest open transaction,” below for information about determining the transaction’s process ID.
To terminate the oldest transaction, enter the process ID (spid) of the process that initiated the transaction. This also terminates any other suspended transactions in the log that belong to the specified process.
For example, if process 83 holds the oldest open transaction in a suspended log, and you want to terminate the transaction, enter:
select lct_admin("abort", 83)
This also terminates any other open transactions belonging to process 83 in the same transaction log.
To terminate all open transactions in the log, enter:
select lct_admin("abort", 0, 12)
