Ensuring data integrity with commitment control
Commitment control allows you to define and process a number of changes to database files in a single unit (transaction).
Commitment control ensures that complex application transactions are logically synchronized, even if the job or system ends. Two-phase commitment control ensures that committable resources, such as database files on multiple systems, remain synchronized.
You implement commitment control in your database by executing commit and rollback operations. Using SQL, you use the COMMIT and ROLLBACK statements.
- Transactions
A transaction is a group of changes that appear as a single change, such as the transfer of funds from a savings account to a checking account.
- Benefits of using commitment control
Recovering a complex application requires detailed application knowledge. Programs cannot be restarted. In this case, commitment control helps solve these problems.
- Usage notes: Commitment control
The commit and rollback operations are available in several programming languages that are supported on the i5/OS operating system, including RPG, COBOL, PL/I, SQL, and CL.
Parent topic:
Recovering data in a database file
Related concepts
Commitment control
Related reference
COMMIT
ROLLBACK