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 iSeries™ Navigator. 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.
- In iSeries Navigator, expand the system with the object you want to journal.
- Expand Databases and the database with the object you want to journal.
- Expand Schemas and select the schema with the object you want to journal.
- Click Tables.
- Right-click the table you want to journal and select Journaling.
You can also use the STRJRNPF command to start journaling physical database files.
Parent topic:
Starting journalingRelated concepts
Reasons to journal before-imagesRelated tasks
Methods to estimate the size of a journal receiverRelated reference
Start Journal Physical File (STRJRNPF) commandRelated information
DB2 Universal Database