15. Performing Backup and Recovery : Journals : Methods for Stopping Journaling on All Tables
 
Share this page                  
Methods for Stopping Journaling on All Tables
You can stop journaling all the tables in a database with either of the following commands:
Altering a database using the alterdb command.
Creating a checkpoint using the ckpdb -j command.
Note:  This takes effect immediately; therefore, it must be used only for emergencies. For information, see Disabling Journaling When Checkpointing (see page Disable Journaling When Checkpointing).
To re-enable journaling on a table or database that has had journaling disabled, use the ckpdb command, as described previously.