Commitment control

Commitment control is a function that ensures data integrity. It defines and processes a group of changes to resources, such as database files or tables, as a transaction.

Commitment control either ensures that the entire group of individual changes occur on all systems that participate in the transaction, or ensures that none of the changes occur. Db2 for IBM i uses the commitment control function to commit and rollback database transactions that are running with an isolation level other than *NONE (no commit).

You can use commitment control to design an application so that the system can restart the application if a job, an activation group within a job, or the system ends abnormally. With commitment control, you can have assurance that when the application starts again, no partial updates are in the database due to incomplete transactions from a prior failure.

Note: By using the code examples, you agree to the terms of the Code license and disclaimer information.