Re: Writing records to database.

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Forgive me for digging up the dead, (but still warm).  Just got back.

Granted changing FRCRATIO can be a performance pig.  But, what about a DR
situation?  Wouldn't you want all records written to dasd in case of
abnormal termination?  If I trip on the power cord and it gets yanked,
what happens to these records?

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




Scott Klement <klemscot@klements.com>
Sent by: rpg400-l-admin@midrange.com
10/01/2002 10:35 AM
Please respond to rpg400-l


        To:     rpg400-l@midrange.com
        cc:
        Fax to:
        Subject:        Re: Writing records to database.



No!  Please DO NOT use CHGPF or CHGLF to change FRCRATIO to 1.   You'll
make the file writes much slower, and by changing the file itself, you'll
slow down every single program that writes to it!!

Usually, the reason this comes up is that your program is calling another
program.   That new program needs to see the records, and cannot because
they haven't been written to disk.

The fix is simple.   Use the FEOD op-code on the file before calling the
program.  FEOD will force all records to the file, so that they can be
read.

If you only use FEOD when you need to (rather than with every write)
you'll still have a program that performs well -- and more importantly,
you won't impact the performance of every other program on the system.

If you MUST change the FRCRATIO, do it for your program ONLY using an
OVRDBF command... but again, I recommend FEOD instead.


On Tue, 1 Oct 2002, Raul A Jager wrote:

> use CHGPF or CHGLF and set   FRCRATIO to 1
>
> >I am trying to write a record to the database file through RPGIV pgm.
> >Though the write is successfull , I am not able to see the records in
> >the file as long as the program is active.
> >
> >Once the program is terminated I am able to see the record written.
> >
> >I am not able to find the reason for this , The file is not journalled
> >& it is not open in the commit mode in the pgm.
> >
> >Can anyone please let me know the reason for this.
> >
> >Thanks in advance
> >Vishnu
> >

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.