Where is Audit Info Store

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
caseywhite
Posts: 192
Joined: Thu May 26, 2016 1:17 am

Where is Audit Info Store

Post by caseywhite »

Does anyone know which file either on IBM i or Windows that the audit info about a function source is stored. On green screen you can see the user, date, time and task by pressing F9 when a function is open. On Windows you can see this beside each line of code by enabling the audit info. I want to query this table to verify what lines of code were changed in which functions for a certain task. I can't seem to find where this is stored. I see some cryptic data in DC@F85 but can't seem to sort out how to read it or if that is even it.
MarkDale
Posts: 116
Joined: Wed Dec 02, 2015 10:06 am

Re: Where is Audit Info Store

Post by MarkDale »

Hi Casey,

If its lansa function source,
IBMi - the line source is in DC@F29 (command) and there are multiple DC@F30 records for each line. I think the audit info is appended to the end of the value in F30PRM on the last DC@F30 for the source line.

Windows - I think LXXF29 has all the source for a line of source.

(Thats assuming it is lansa function source you want. Component source (reusable parts etc) is in DC@FRD / LXXFRD)

(I think thats right, though I don't have a lansa installation to check)
René Houba
Posts: 220
Joined: Thu Nov 26, 2015 7:03 am

Re: Where is Audit Info Store

Post by René Houba »

Hi Casey,

Do you want to see this information on the iSeries or Windows?
caseywhite
Posts: 192
Joined: Thu May 26, 2016 1:17 am

Re: Where is Audit Info Store

Post by caseywhite »

Thanks Mark.

Windows was much easier to read. I found it as you said in LXX29 in the column X29PRM. Below are the positions of the values I was looking for. Seems like the audit info is at the start.
Date: 10
User: 18
Task: 28

I only needed function source for now but I checked LX_FRD and see that it stores the info at the end of the line rather than at the start.

With this info in hand I have what I need.

Thanks again.
caseywhite
Posts: 192
Joined: Thu May 26, 2016 1:17 am

Re: Where is Audit Info Store

Post by caseywhite »

Hi Renee. IBMi or Windows is fine. Based on the info from Mark it appears that it is easier to read it in Windows from what I can see, but if you have some tips on reading it on IBMi I would appreciate the tips.

Thanks.
René Houba
Posts: 220
Joined: Thu Nov 26, 2015 7:03 am

Re: Where is Audit Info Store

Post by René Houba »

Hi Casey,

I was thinking about the iSeries Impact List option, but I just checked: you can't check for task details there!!
Post Reply