Was this helpful?
Committing Transactions
When a transaction is committed, its effects on the database are made permanent and visible to other users. Before a transaction is committed, none of its updates to the database are visible to other users, and the transaction can be aborted. An SQT is committed upon execution (barring errors). An MQT is committed when the end transaction statement is executed.
Note:  Under certain circumstances, the effects of an uncommitted transaction are visible to other users. For details, see Set Lockmode Option on page 81.
Last modified date: 11/28/2023