Journaling database physical files (tables)

When you start journaling a physical file (table), you specify whether you want after-images saved, or both before-images and after-images.

To reduce the number of journal entries, you can omit entries for open operations and close operations for the file. To omit open and close entries from being journaled, select the Exclude open and close entries in IBM Navigator for i. Or you can Specify OMTJRNE(*OPNCLO) on the Start Journal Physical File (STRJRNPF) command. If you choose to omit open journal entries and close journal entries, be aware that:

  • You cannot use the journal to audit who has accessed the file.
  • You cannot apply or remove journal changes to open boundaries and close boundaries using the TOJOBO and TOJOBC parameters.
To start journaling for physical database files, follow these steps.
  1. With Navigator for i, connect to the system with the object you want to journal.
  2. Expand Databases
  3. Click Set Database/Schema to use with Database Tasks and set the database and schema that contain the object you want to journal.
  4. Click Tables.
  5. Select the table that you want to journal and select the Journaling action.

You can also use the STRJRNPF command to start journaling physical database files.