SQL Reference Guide > SQL Reference Guide > Working with Transactions and Handling Errors > Transactions > How the Transaction Processing System Handles Interrupts
Was this helpful?
How the Transaction Processing System Handles Interrupts
When an operator interrupt occurs on the currently executing transaction, the Ingres transaction processing system responds according to the operating system used:
Windows: The Ingres transaction processing system recognizes the interrupt signal, Ctrl+C. When the user enters a Ctrl+C through a terminal monitor during transaction processing, the DBMS interrupts the current statement and rolls back any partial results of that statement. Additional use of Ctrl+C is ignored (unless an additional statement is added to the transaction). The transaction remains open until terminated by a COMMIT or ROLLBACK statement.
UNIX: The Ingres transaction processing system recognizes the interrupt signal Ctrl+C. When the user enters a Ctrl+C through a terminal monitor during transaction processing, the DBMS interrupts the current statement and rolls back any partial results of that statement. If there is no statement currently executing, Ctrl+C has no effect. Ctrl+C has no effect on the state of the transaction and does not cause any locks to be released.
VMS: The Ingres transaction processing system recognizes two interrupt signals, Ctrl+C and Ctrl+Y, when they are entered through a terminal monitor. When the user enters a Ctrl+C through a terminal monitor during transaction processing, the DBMS interrupts the current statement and rolls back any partial results of that statement. If there is no statement currently executing, Ctrl+C has no effect. Ctrl+C has no effect on the state of the transaction and does not cause any locks to be released.A Ctrl+Y character causes the DBMS to roll back a transaction in progress. The use of Ctrl+Y and the use of the VMS STOP command are strongly discouraged.
Last modified date: 08/28/2024