SunshineVK
asked on
Track journaling pf on ibm iseries AS/400 machine for os user?
os/400 ibm iseries server to tack user changes on pf
ASKER
Hello Dave,
Thanks for your immediate response.
We already have a journaled environment on the iSeries. What we are looking out is for a method to read the Journal entries. I have generated a couple of reports with the command DSPJRN and CMPJRNIMG, but from the data displayed in "ÉNTRY SPECIFIC DATA" column, we are not able to make out which particular field in the physical file is updated / deleted and also some of the data is in the formn
of junk characters.
Is there a way to generate a report in a more readable format without using a third party tool as this is an audit requirement? Does using the command RTVJRNE in a CL prog help?
Thanks for your immediate response.
We already have a journaled environment on the iSeries. What we are looking out is for a method to read the Journal entries. I have generated a couple of reports with the command DSPJRN and CMPJRNIMG, but from the data displayed in "ÉNTRY SPECIFIC DATA" column, we are not able to make out which particular field in the physical file is updated / deleted and also some of the data is in the formn
of junk characters.
Is there a way to generate a report in a more readable format without using a third party tool as this is an audit requirement? Does using the command RTVJRNE in a CL prog help?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SunshineVK:
Also review this EE item closely:
https://www.experts-exchange.com/questions/21347686/Notification-of-a-field-being-updated-in-a-file.html
It's a little more complex than Dave's example, but it might help illuminate what can be done. If the first couple of preparatory steps are done, you can create a general proc that will automate this for any journaled table.
Tom
Also review this EE item closely:
https://www.experts-exchange.com/questions/21347686/Notification-of-a-field-being-updated-in-a-file.html
It's a little more complex than Dave's example, but it might help illuminate what can be done. If the first couple of preparatory steps are done, you can create a general proc that will automate this for any journaled table.
Tom
ASKER
Thanks Tom & Dave.
Problem was resolved using Daves suggestion.
Thanks for inputs Tom.
Problem was resolved using Daves suggestion.
Thanks for inputs Tom.
what is it you want? the heading is not very helpful!
You can create a journal receiver (CRTJRNRCV)
Then create a journal CRTJRN specifying the receiver.
Then attach the files to the journal STRJRNPF.
you then use the DSPJRNcommand to show what has changed.
if you want to show who has looked at records, added as well as changed them then you can use a database trigger and write your own audit.
Dave