Re: SYSTEM21 Digest, Vol 10, Issue 6

"Deon A von Blerk" <[email protected]> Fri, 27 Jan 2012 20:27:10 +0100
Newsgroups gmane.comp.systems.as400.jbausers
Message-ID <000001ccdd29$abd1c1f0$037545d0$@com>
I agree with Geoff. Added to that is the fact that many of the S21 files
have no audit e.g. INP15.

Regards

Kit
www.ecofitonline.com


> ----------------------------------------------------------------------
> 
> message: 1
> date: Fri, 27 Jan 2012 00:01:04 +0000
> from: Geoff Boreland <[email protected]>
> subject: Re: [SYSTEM21] System21 - Time from Pick Note to Despatch
> 	Note
> 
> You might also want to contemplate the use of database triggers to
> ensure you capture all the information required.
> 
> A typical audit file is only ever going to be as useful as all of the
> programs that write / update it.  As soon as someone performs a write
> or an update to the master file without including the audit file, then
> the audit trail is compromised.
> 
> We have found that installing database triggers will ensure you capture
> all database I/O's including SQL / DFU style updates, as the I/O is
> performed at the operating system level and not within the program.
> 
> Regards
> Geoff

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.