Transactions

A transaction is a series of one or more operations on database-related objects, data, or both.

Transactions provide the following benefits:

Ensure integrity among multiple operations by allowing all or none of the operations to take effect. You accomplish this by starting a transaction, performing operations, and then executing either a commit or a rollback (also called an abort).
Provide a means of canceling completed work for a series of operations that fail before finishing.
Provide a consistent view of data to users, in the midst of changes by other users. The combination of create and delete transaction IDs associated with each data row plus Netezza Performance Server for Cloud Pak for Data and Netezza Performance Server for Cloud Pak for Data System internal controls ensure that after a transaction begins, new transactions or ones that have yet to be committed do not affect the view of the data.