Home > IT Answers > AS/400 > QGPL JOURNAL ENTRIES
Donn
20 pts.
 QGPL JOURNAL ENTRIES
AS/400 journaling, QGPL, QGPL 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

Software/Hardware used:
ASKED: May 1, 2009  7:17 PM
UPDATED: May 5, 2009  5:35 PM
RELATED QUESTIONS
Answer Wiki:
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 -------------------------
Last Wiki Answer Submitted:  May 5, 2009  5:35 pm  by  Cwc   4,275 pts.
All Answer Wiki Contributors:  Cwc   4,275 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

Gilly400
 23,625 pts.
 

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/

Davidfree007
 90 pts.