Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Database file types » The transaction log


Determining which connection has an outstanding transaction (SQL)

You can use a system procedure to determine which user has outstanding transactions.


You must have the SERVER OPERATOR, MONITOR, or DROP CONNECTION system privilege.

Context and remarks

If you are performing a backup that renames or deletes the transaction log, incomplete transactions are carried forward to the new transaction log.

  1. Connect to the database from Interactive SQL.

  2. Run the sa_conn_info system procedure:

    CALL sa_conn_info;


Inspect the UncommitOps column in the Results pane to see which connection has uncommitted operations.


If necessary, you can disconnect the user with a DROP CONNECTION statement.

 See also