Transaction control and monitoring
From a management/administrative perspective:
- Using the nzsql command (or any other SQL front end), privileged users can start, commit, and abort a transaction. User must have list object privileges on the database to which they are connected.
- Using the nzsession command, privileged users can list and abort currently running SQL transactions.
If the system encounters a deadlock as it is processing transactions, it aborts one of the deadlocked transactions and displays Deadlock detected, resubmit your request.