RE: Audit journal create object entries question

Is the program SQLRPGLE? I seem to recall some posts by Rob Berendt about the access paths being updated in the object every time it is used (or something like that).
--
Sean Porterfield


-----Original Message-----
From: lgoodbar@xxxxxxxxxxxxxx
Sent: Wednesday, December 10, 2008 12:06
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Audit journal create object entries question

Some followup.

I reviewed the journal entry for the command IMPLOOKUP, and the value for Entry Type is R. (N = Creation of new object, R = replacement of existing object) The program logged as "creating" the command is WVCPLNR. That is a CL program (menu driver), and only one line references IMPLOOKUP:

0145.00 ? implookup
010219

How does prompting a command cause it to be "created" or "replaced"?

I'm not sure that excluding "replacement" entries from our audit process would be wise. Checking to see how an Aldon-promoted object looks to the journal.

--Loyd


-----Original Message-----
From: lgoodbar@xxxxxxxxxxxxxx
Sent: Wednesday, December 10, 2008 8:25 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Audit journal create object entries question

We use the audit journal to capture object creation activity, journal code T, entry type CO. Almost all new objects in the production environment should be tied to a help desk or CMS ticket. The usual exceptions are for dynamic report generators (such as MRC) that create programs at run-time. We filter out obvious exceptions (system objects, objects in IBM libraries, various IFS paths, etc.) and try to report things that should have a documented change request.



Occasionally we will see entries for object creation that do not match the object description. For example I have journal entry for command object PROD_MOD/IMPLOOKUP, created by SHERMAN on 2008-11-14, 12:24:45.
When I look at the object description, it shows Creation date/time (MDY) is 02/16/01 14:49:53. It does, however, have a change date of 11/14/08, 12:24:45. Last restored on 3/27/04. Why would changing an object cause a create object journal entry?



Has anyone run into this situation before?



Thanks,

Loyd

This email is confidential, intended only for the named recipient(s) above and may contain information that is privileged. If you have received this message in error or are not the named recipient(s), please notify the sender immediately and delete this email message from your computer as any and all unauthorized distribution or use of this message is strictly prohibited. Thank you.