×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
 
Db2 does not "require journaling" unless using COMMITMENT CONTROL.
 
Look at the defaults in your program when you compiled it.  Prompt the CRTSQLRPGI command.  What do you see for:
    Commitment Control . . . :      (it could be *CHG, *ALL, *CS, or *NONE)
If you just took option 14 in PDM, and the default is *CHG. :-/
So, in effect, you told the compiler you want "Commitment Control".
It is commitment control that requires journaling.  
This is also true if you are using native I/O and commitment control.
It has always been this way since at least OS/400 V1R1... and probably S/38 CPF before that.  
On Thursday, May 13, 2021, 3:02:18 PM EDT, <dr2@xxxxxxxx> wrote: 
OK, out of curiosity, why is it a requirement that files be journaled
before you can do programmatic SQL operations against them?  
Ran into CPF4328 this morning and never heard of this requirement
before! 
/DR2
 
As an Amazon Associate we earn from qualifying purchases.