Re: Question on File locking

On 8/13/2014 11:44 AM, Vinay Gavankar wrote:

Problem:

A new Client (US Federal Government) requires detailed audit information

on

the Member file. They assess a penalty of $1 Million for every missed or
incorrect audit information (I don't know if and how they enforce it, but
we are told that is what the contract says).

To be accurate, the audit records need to be in exact sequence of how the
updates to the Member file occurred. (@Buck: If they are not in the

update

sequence, then they would be considered out of sequence).

It probably crossed your mind to change the audit file to not require a
unique key. You probably can't change the file's definition.

It also probably crossed your mind that journalling the Member table
will give you /an/ audit file - but probably not /the/ audit file you want.

Given the very high cost of failure, I suggest journalling the table and
then post-processing the journal to create the audit table in the format
you need. You can have guaranteed chronological order that way.
--buck
--
This is the RPG programming on the IBM i (AS/400 and 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.