15. Performing Backup and Recovery : Journals : Database or Table-level Journaling : Database Journaling
 
Share this page                  
Database Journaling
The recommended approach is to journal the entire database rather than specific tables. Tables in journaled databases are created “with journaling” if that is the default_journaling setting of the server class used by the Ingres DBMS Server you are connected to.
Disable journaling on specific tables only if a rollforward recovery of those tables is not important. You must exercise caution when creating non-journaled tables in journaled databases. Non-journaled tables cannot be audited when the database is audited, nor can they be recovered through rollforward. Following a rollforward recovery, the relationship between journaled and non-journaled tables can be confusing.