Link to home
Start Free TrialLog in
Avatar of SunshineVK
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
Avatar of daveslater
daveslater
Flag of United States of America image

Hi
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
Avatar of SunshineVK
SunshineVK

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?  
ASKER CERTIFIED SOLUTION
Avatar of daveslater
daveslater
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Thanks Tom & Dave.
Problem was resolved using Daves suggestion.
Thanks for inputs Tom.