• June 28, 2022

Journals for Dummies Part 2: Finding Your Journal

In our last post we talked about the basics of journaling. There are two types of journals, the system audit journal QAUDJRN in QSYS and database journals. In this post we will cover how to figure out what is in the database journal.

First you need to find the journal! If you are using iCluster you have a quick method of finding all the journals on the system using the DMWRKJRN command. The Tech Tuesday post back on April 22 2014 covered the DMWRKJRN command in detail. If you don’t have iCluster and you want to know what is happening with a particular file, you need to determine if it is journaled. The way to do this on IBM i is the simple DSPFD command. Issue the command DSPFD <mylib/myfile> and page down twice until you find the field File is currently journaled…. And hopefully this is set to YES.


If it is set to YES, the very next field will tell you the name of the journal for the file. Some additional information is also provided such as whether both before images or just after images are being captured (so in other words is the journal showing me what the record was like before the change and after the change or do you just get the final result). It will also show you what journal entries are being omitted. Usually unless a programmer is doing some testing to see where a program is spending all its time, opens and closes are omitted to reduce the number of transactions generated in the journal receiver.

If the file is not currently journaled – all bets are off! To start journaling on the file use the STRJRNPF command.

Next week we will figure out what is actually in the journal we just found.

iCluster Tech Tuesday 0 Posts

iCluster TechTuesday is a set of posts covering technical tips and techniques to help get the most out of your Rocket iCluster installation.


Leave a Comment

Your email address will not be published.