Re: Journaling and Commitment Control

Yes you can journal without commit control. In fact it’s recommended anyway. It allows the system to use the journals in the event of a recovery. And if you save the receivers more often, your point of recovery could be the last journal save.


Jim Oberholtzer
Agile Technology Architects
Office: 414-433-4363
Mobile: 414-915-1445
Sent from mobile device

On Dec 1, 2023, at 3:17 PM, Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

Our legacy ERP system does not have journaling enabled on any of their database files. I'm currently working on a UI modernization project, and we would like to use commitment control in the new applications we're creating (over the ERP database).

The ERP system using RPG record level access for everything. However, I do have some custom programs accessing/updating these files using SQL. Those programs set the commit option to *none.

So my question is this... if we enable journaling on these files, will that affect any of the existing programs with the commit option = *none?

I've been reviewing the 2019 Articles on IT Jungle, and it seems like we should be OK.
https://www.itjungle.com/2019/06/19/guru-classic-looking-for-commitment-part-1/


TIA,
Greg
[Logo]<https://www.totalbizfulfillment.com/> Greg Wilburn
Director of IT
301.895.3792 ext. 1231
301.895.3895 direct
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
1 Corporate Dr
Grantsville, MD 21536
www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.