Commitment control - skill-at/AS-400-Training GitHub Wiki

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. 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).

STRCMTCTL

The Start Commitment Control (STRCMTCTL) command is used to establish either a job level or activation group level commitment definition.

Before a commitment definition is established, the user must ensure that all database files that are to be opened under commitment control for a single commitment transaction are journaled.

Ending commitment control

The End Commitment Control (ENDCMTCTL) command ends commitment control for either the job-level or activation-group-level commitment definition.

Issuing the ENDCMTCTL command indicates to the system that the commitment definition in use by the program making the request is to be ended. The ENDCMTCTL command ends only one commitment definition for the job and all other commitment definitions for the job remain unchanged.