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.
Connect to the database from Interactive SQL.
Run the sa_conn_info system procedure:
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|