Re: Question on Audit Journal Entries

[Jack Kingsley <iseriesflorida@xxxxxxxxx>]

I would look at more fields than just this.



On Fri, Oct 1, 2021 at 8:57 AM Andrew Lopez (SXS US) <
Andrew.Lopez@xxxxxxxxxxxxxxxxxx> wrote:

> Specifically, where:
>
> -          AFCODE = 'T'
>
> -          AFENTT = 'AF'
>
> -          AFVIOL = 'R'
>
> -          AFOTYP = '*OCUR'
>
> I have these popping up when we run some SQL extracts from a file.  The
> file in question is owned by the user profile shown in the log entry (for
> both User Name and User Profile).  The file in question has its authorities
> set to *PUBLIC *AUTL, and the associated Authority List has this same user
> with *ALL.
>
> Where should I look for the cause of this entry?  It isn't stopping the
> Sequel View from running, but it is creating hundreds of entries that I
> would like to eliminate.  This profile uses and updates this file thousands
> of times per day, with the only audit journal entries being when this query
> is run.
>
> My guess is that *OCUR, which represents some kind of cursor use, is the
> cause.  But I can't find any indications how I would make this disappear.
> Or even for that combination of audit log journal fields.
>
> I welcome any suggestions for what I should look for here.
>
>
> _____________________________________________________________________
> Spirax-Sarco Engineering Plc.  This e-mail has been scanned for viruses by
> Cisco Cloud Email Security.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com