Journalling PF in AS400

280 pts.
Tags:
AS/400 journaling
PF
Physical Files
Hi,

I would like to know when a PF is added with some new entries, or the existing entries been modified. 

I require a report to be printed with the users and time of update.  How this could be achieved easily?



Software/Hardware used:
AS400

Answer Wiki

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

I have done the following thing:

1. Create a journal (CRTJRN)
2. start journalling the target physical file (STRJRN)
3. Get the report with help of DSPJRN command.

Is this OK, will it have any impact or is there any other easy way to do this?

_______________________________

That’s the right way to go about it. Just insure the audit journal is managed by *USER and not *SYSTEM or they may be deleted before you have the chance to generate a report.

Discuss This Question: 5  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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Rajgoaj
    Also would like to know what is the relevance for journal receiver
    280 pointsBadges:
    report
  • Whatis23
    The only concern (if that is what you mean by relevance) is the possibility of increased DASD usage. This all depends on how many objects are being journaled and the activity of those objects creating an extraneous amount of entries. Just verify how many audit receivers you can afford to keep on the system.
    5,665 pointsBadges:
    report
  • TomLiotta
    what is the relevance for journal receiver A journal holds the description of what all is being journaled and how journaling is to be applied. The journal receivers hold the transactions that result from journaling. will it have any impact or is there any other easy way to do this? Of course it will have impact. Every program or function that uses a CPU cycle or a byte of storage always has impact. But there's no way for us to tell if the impact will be noticeable nor even if it will have a positive or negative impact on your system. There are circumstances where journaling can improve performance. (Not common, but possible in commitment control areas.) Tom
    125,585 pointsBadges:
    report
  • Rajgoaj
    Thanks, so do I use RMVJRNCHG to clear the journal receiver? Could you please give me what all parameters to be taken care while executing this command?
    280 pointsBadges:
    report
  • TomLiotta
    Journal receivers cannot be cleared. They are intended for guaranteed audits as well as database integrity. Entries are not allowed to be deleted. Journal receivers are deleted once they are no longer useful. Use DLTJRNRCV to delete receivers. Usually, receivers are expected to be saved before deletion. The RMVJRNCHG (Remove Journaled Changes) command is used to reverse transactions from a file. When updates, insertions and deletions are done against a file, they are all logged in the journal receiver. If problems are found in the transactions, you use RMVJRNCHG to undo the changes from the file. If none of the transactions are ever needed again, the receiver can be deleted. Deletion of receivers may be done manually. It's often much better to let the system do it automatically. You make the choice when you create the journal. Tom
    125,585 pointsBadges:
    report

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following