20 pts.
AS/400 journaling
Our AS400 has been having jounal entries show up in QGPL. They are taking alot of disk space. How can I identify what is creating this journals and how do I stop them from being generated. I tried a DSPJRN command and did not get much info Thanks Donn

Answer Wiki

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

With the WRKJRNA (work with journal attributes) command, you can see which journal receiver is currently attached to the journal, and which files or other objects are journaled (via the F19 key).

Then, you’ll have the infomation you’ll need to determine what type of changes you want to make to your journaling, such as whether you want the system to manage the receivers or if you want to manually do so and whether you want to continue journaling certain objects or not.

To end journaling for a specifc file, use the ENDJRNPF command. The system will need an exclusive lock on the file to end jounaling, so if other programs are running which use that file, you will need to wait until those jobs end. Depending on your applications, usually a good time for this would be after users are signed off of the system and before any nightly batch jobs start running.


Thanks for update…………….It proved successful

Discuss This Question: 2  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.
  • Gilly400
    Hi, It might be worth bearing in mind that your application programs may need to have their files journalled. If your programs are using commitment control for example, you may get errors if you stop journalling your database files. Regards, Martin Gilbert.
    23,730 pointsBadges:
  • Davidfree007
    Agree with Gilly. The journal information will show you which program is generating the journal entries, so should be able to track down which app is using these journals. Have you created any files using SQL? This sometimes automatically creates journals and journals receivers for you if you use commands such as CREATE TABLE to create file with commitment control enabled, so worth checking. http://as400blog.blogspot.com/
    90 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: