Re: lose data during system crash

How many duplicates are you seeing?
If you are seeing more than one, then I think you have other problems.
My reasoning is that to update the record, you need to lock the file, and
therefore stopping any other updates. When the system crashed, I believe
only one record can be updated at that time. Hence, my reasoning.
This could mean that I have a brain like Sherlock Holmes, or conversely,
Inspector Cleausaeu



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill

rpg400-l-bounces@xxxxxxxxxxxx wrote on 10/29/2007 04:55:22 PM:

We have a RPG program that uses a record in a file to keep tracking of
the next shipment-tracking#. It returns the next tracking# to the
caller and update the record. Our system crashed this Friday and we are
now seeing duplicate shipment-tracking # in our order entry file. It
seems like the update that happened on the day that system crashed
somehow got lost. I know RPG does blocking when file is opened with
output only. However, this program does not write to this file, it only
does updated.
Is it possible for data being updated by this RPG program to get lost
after system crashed?

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.