Enable Journaling on an Entire Database
To journal an entire database
Issue the following command at the operating system prompt:
ckpdb +j dbname
or
Use the SET JOURNALING (or ING_SET "set journaling" equivalent) statement to enable journaling of all activities associated with the database.
Note: The only tables that are enabled are those whose journaling status is “enabled after next checkpoint.” Tables whose journaling status is “disabled” cannot be enabled.