AS/400 Physical File update history

120 pts.
AS400 physical file
Physical File
How can we find out the sequence of programs that have updated the fields of the given file.

For eg. If I have a file ABC and 10 programs have updated the file ABC, then how can we find out in which sequence the programs have updated the file ABC and what was the value in fields after each sequence?


Answer Wiki

Thanks. We'll let you know when a new response is added.

You can do this by Jouirnalling the File
CRTRCVJRN – Give it any name you want and usually best to put in th the same library as the objects you will journal. This is done for recovery process if ever needed.

CRTJRN – Same as above

STRJRNP – I usually omit the open/close and journal both the before and after images.

This will automatically log every add/update/delete to the file with the data and additional information such as who, what, when, where.

This can be done at anytime.
If you decide to end the process at some time, you do an ENDJRNPF command
Here is a link to information regarding an easy way to display the information once collected.
It is from a response question yesterday.

Discuss This Question: 6  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Lovemyi
    without the file already being journalled there is no way to see this information. All you can do is journal the file and run the same programs again over the file to see the journal receiver details which will show you the programs and the order they are touched.
    2,310 pointsBadges:
    Depending on how you dump the journal we can see the before and after result of each update and the sequence it happened. The output of the dump contains the entire record, but it is one string of data matching your physical record layout.
    1,235 pointsBadges:
  • CharlieBrowne
    The EXPJRNE will split that character string into individual fields. Here is the link .
    62,385 pointsBadges:
  • DanTheDane
    As an alternative to journaling, you may create a trigger-program which writes a record with the 'before-update' data plus add'l info like program-name, timestamp, userid. Thus you have full control in respect of which data your 'log' needs to contain. This url brings you to explanatons and sample code on triggerprogramming. Good luck DanF
  • DanTheDane
    This is not to gain points - the 'link' in the editor is most probpably the cause to my problems to pass the url i refer above. I'll give it a last try by putting it here as pain text:
    2,555 pointsBadges:
  • Modiyooch
    once journalling,the command CMPJRNIMG (compare journal images) is a big help to zero in on fields changed and order of the update programs.
    850 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: