×
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.
Daniel/Charles - thank you very much!
I only have two files in my ERP that show up in the select below.
I will search the CL source code for FRCRATIO override. But In 25 years, I've not seen that anywhere.
FWIW - it is amazing what you find in your current environment when examining it this closely (during a project).
I'd also like to say just how invaluable the midrange lists are.
Thank you all again!
Greg
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Daniel Gross
Sent: Monday, December 4, 2023 3:36 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Journaling and Commitment Control
On Mon, Dec 4, 2023 at 12:21 PM Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
I don't know that any of our tables have FRCRATIO(1)... how can I tell?
On 04.12.2023 at 21:27 Charles Wilt <charles.wilt@xxxxxxxxx> wrote:
DSPFD...
I think it is even easier with SQL:
select * from sysfiles where force_write_ratio = 1 ;
This should give you all files, that are configured with FRCRATIO(1).
Here a the docs:
https://www.ibm.com/docs/en/i/7.5?topic=services-sysfiles-view
HTH
Daniel
midrange.com
