RE: Audit journal entries

["Walden H. Leverich III" <WaldenL@xxxxxxxxxxxxxxx>]

>So an RPG program using a file for update in its F-specs would 
>create such an entry? AFAIK the program in question here 
>leaves with RETRN - shouldn't the file stay open?

Yes. But what program is actually creating the audit entry? The one that
leaves with RETRN, or one that IT CALLS when processing a row. What's the
program on the Audit entry? (if there is one, I don't remember, if not,
journal the file w/opnclo for a day and check there.)

-Walden

------------
Walden H Leverich III
President
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 

-----Original Message-----
From: ouuch@xxxxxxxxxxx [mailto:ouuch@xxxxxxxxxxx] 
Sent: Tuesday, May 06, 2003 3:16 PM
To: Midrange Systems Technical Discussion
Subject: RE: Audit journal entries


On 6 May 2003 at 11:53, John Earl wrote:
> A ZC is an Audit Type entry that indicates that an object was changed - or
> more exactly in the case of a data file - that the file was opened for
> change. 
So an RPG program using a file for update in its F-specs would create such
an entry? AFAIK 
the program in question here leaves with RETRN - shouldn't the file stay
open?

>If you are getting 200K of these an hour, one has to wonder about
> the efficiency of the program (Note: this is an example of the QAUDJRN
> acting as a performance sleuth).  It would seem to indicate that a program
> is opening and closing the file 200,000+ times per hour.

I know we should rewrite this program. But the job is very complicated and
has lots of 
intermixed programs and calls. Gee, our project plans already has us maxed
out until
October or so.

> One more thought - the ZC entry is likely the result of someone turning on
> object auditing for either the file in question, or for the User who is
> running the batch job.  You may want to look at those two items to
determine
> if that level of auditing is appropriate - after you address the
performance
> issues.

Audit journalling has been turned on for DataMirror. And these lots of audit
entries seem to 
create some problems in the mirroring.

Regards,

Oliver
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.