Справочник Пользователя для 7signal INDR-EYE01
11 Command-line tool for database management
70
7signal Solutions Inc., 526 S. Main Street, Akron, Ohio 44311, USA, 855-763-9526, info@7signal.com,
www.7signal.com
7
sig
n
al
Sa
p
p
h
ire
D
ep
lo
yme
n
n
t
G
u
id
e R
ele
as
e 5
.0
11 COMMAND-LINE TOOL FOR DATABASE
MANAGEMENT
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.
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.
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.
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.
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.
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>
o weekly <DDD> <HH:mm> <backup directory>
<DDD> = Mon, Tue, Wed, etc.
o monthly <day> <HH:mm> <backup directory>
o directory <backup directory>
o directory <backup directory>
Backup directory is optional if a backup
configuration already exists.
configuration already exists.
now
Immediate backup.
o
online
o
offline