User Guide Part 2

26 7signal solution 138
7signal Solutions, Inc., 526 S. Main Street, Akron, Ohio 44311, USA, 855-763-9526, [e-mail], www.7signal.com
7signal Sapphire Carat User Guide Release 5.0
Example:
# 7db backup set daily 03:00 /mnt/backups
Automated backup without server downtime
Online backup is a circadian backup that keeps 7signal Sapphire in production while creating
the backups.
Database logging method must be archival logging.
Example:
# 7db backup set daily 03:00 /mnt/backups
# 7db backup set type online
Manual backup
Circular logging
Sapphire processes will be stopped during backup process and automatically restarted after
backup has been created.
Example:
# 7db backup now /mnt/backups offline
Archival logging
Sapphire processes will not be stopped during backup process.
Example:
# 7db backup now /mnt/backups online
26.2.2 Database logging
In short, the logs of a database system are the most precious. It is justified to say that the logs
are the database as they are written first and the tables are updated after that.
IBM DB2 provides alternative logging methods that affect the backup options. So called
'circular logging' method keeps the size of the logs very predictable. The other option used in
7signal Sapphire is so called 'infinite archive logging'. This is very flexible a logging method
provided that there is a special file system available. Practically the file system must not fill up
ever.
The default logging method in 7signal Sapphire is 'circular logging'.
Purging database logs
Circular logging