QGPL JOURNAL ENTRIES

20 pts.
Tags:
AS/400 journaling
QGPL
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.

CWC

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.

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
  • 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:
    report
  • 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:
    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