Relation between journalling and commitment control

543 Views Asked by At

This question is specific to database files in an iSeries database. If a file is journalled, is commitment control mandatory when using the file in programs (updating and writing to the files)?

2

There are 2 best solutions below

7
On

The default is for commitment control when programs are created. However, Commitment control is not mandatory.

2
On

No. Journaling does not require commitment control. However, commitment control requires journaling (unless the file in question is only open for reading).

I haven't been able to find an independent source which explicitly states that journaling does not require commitment control, but it is implied when discussing the process of setting up commitment control, such as in this article. Clearly, you can set up journaling without setting up commitment control.