User Guide

11 Command-line tool for database management 70
7signal Solutions Inc., 526 S. Main Street, Akron, Ohio 44311, USA, 855-763-9526, [e-mail],
www.7signal.com
7signal Sapphire Deployment Guide Release 5.0
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
 reorg Reorganize the database
 db2 Access to database management system command-line tool
11.1 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.
11.2 Backup command group
Creates instant and automatic database backups. It is possible to schedule one offline and/or one online
backup point.
NOTE: the backup policy should be well-planned. Please see the 7signal Sapphire User
Guide for further discussion on backup and the options available.
Backup commands:
 show Show automatic backup configuration
 remove Remove automatic backup configuration
 set Configure automatic backup
o daily <HH:mm> <backup directory>
o weekly <DDD> <HH:mm> <backup directory>
<DDD> = Mon, Tue, Wed, etc.
o monthly <day> <HH:mm> <backup directory>
o directory <backup directory>
Backup directory is optional if a backup
configuration already exists.
 now Immediate backup.
o online
o offline