Disable Journaling
To disable journaling
Use either of these methods:
• Use the WITH NOJOURNALING option of the CREATE TABLE statement on new tables.
For example, to turn journaling off when you create the emp table, issue this statement:
CREATE TABLE emp
name varchar(20),
age i2,
salary money)
WITH NOJOURNALING;
• Set journaling off for an entire session with the SET NOJOURNALING option of the SET statement, for example:
SET NOJOURNALING;