User's Manual

11 Command-line tool for database management 64
7signal Ltd, Panuntie 6, FI-00620 HELSINKI, FINLAND, [phone], [e-mail], www.7signal.com
7signal Sapphire Deployment Guide Release 3.1
11 COMMAND-LINE TOOL FOR DATABASE
MANAGEMENT
7db command is a tool for Carat database. It supports limited data retrieval, general
management and database backup administrator for both immediate and automatic backups.
It is recommended that database backups should be taken regularly.
7db command groups:
 dump Dump export and import
 show Show status and configurations
 reinit Re-initialize databases
 backup Automatic backup management
 logsetup To change the current logging method
 db2 Access to database management system command-line tool
11.1 Dump command group
Creates an instant database backup dump or restores previous backups.
Examples:
Make a dump to a gzipped tar file
# 7db dump export
Import a dump
# 7db dump import 7signal-dump.tgz
11.2 Logsetup command
Changes the way the underlying DBMS handles logging.
NOTE: the command is trivial to issue but it’s consequences are highly resource
consuming. Observe awareness when using this command.
There are two different logging modes in 7signal Sapphire. This command switches between
the modes. There is lots of informative output as this command should not be used carelessly
or without proper planning and understanding of the consequences.
The command examines the current state of all three different underlying databases. In case
they differ from each other, the processing shall stop as it is expected that all the databases
are handled similarly. In case the logging method differs, there has been some significant error
in DB administration and system otherwise.
The logsetup command may result in numerous backups for the safety reasons so the overall
process duration is rather long.