15. Performing Backup and Recovery : Journals : Disable Journaling
 
Share this page                  
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;