[NO]JOURNALING
The default for journaling for a DBMS Server is established by the DEFAULT_JOURNALING option in CBF. Default journaling can be overridden by the SET [NO]JOURNALING statement, which then defines the default journaling state for tables created by the session after the statement is issued. If a table is created with the WITH [NO]JOURNALING clause that becomes the default journaling state for that table.
IMPORTANT! Regardless of whether journaling is enabled for a table, journaling only occurs when journaling is enabled for the database. Journaling for the entire database is turned on or off using the ckpdb command. For details about ckpdb, see the Command Reference Guide.
If the current journaling status of the table is OFF, and you want to enable journaling for the table after the next checkpoint, use the SET JOURNALING ON tablename statement.
Note: Journaling status can be enabled only when table is first created or after a checkpoint in which case the checkpoint has a consistent version of the table against which subsequent journals can be applied.
To disable journaling against a table, use the SET NOJOURNALING ON tablename statement.
Avoid using NOJOURNALING in the following scenarios since it can cause restore failures and database inconsistency:
• When a table is created with NOJOURNALING in an incremental rollforward scenario, views dependent on that table become unusable after rollforward, since the base table is not restored.
• When performing incremental rollforward on a checkpoint created before the NOJOURNALING table, journal records cannot be applied to that table. Due to this, rollforward fails with multiple errors, database is marked inconsistent, and the table becomes inaccessible.
To disable journaling, plan for a non-incremental restore cycle instead.
The HELP TABLE tablename statement shows the journaling status of a table. The infodb command shows the journaling status of a database. Journaling can be stopped for a database by using the -disable_journaling option of the alterdb command or ckpdb with the -i flag. (For details, see the Command Reference Guide.)
Last modified date: 07/15/2026