Protecting your files with journaling and commitment control

 

Journaling and commitment control are the preferred methods for i5/OS^® data and transaction recovery. You can use the COMMIT parameter to protect your file with journaling and commitment control.

Database file journaling is started by running the Start Journal Physical File (STRJRNPF) command for the file. Access path journaling is started by running the Start Journal Access Path (STRJRNAP) command for the file or by using System-Managed Access-Path Protection (SMAPP). You tell the system that you want your files to run under commitment control through the Start Commitment Control (STRCMTCTL) command and through high-level language specifications. You can also specify the commitment control (COMMIT) parameter on the Open Database File (OPNDBF) and Open Query File (OPNQRYF) commands.

If you are performing insert, update, or delete operations on a file that is associated with a referential constraint and the delete rule, update rule, or both are other than RESTRICT, use journaling.

 

Parent topic:

Data recovery and integrity

 

Related concepts

Managing journals
Ensuring data integrity with commitment control
Ensuring data integrity with referential constraints