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.