@data
|
Reads options
from the specified environment variable or configuration file. If
both exist, and share the same name, Sybase IQ uses the environment
variable. For more information about configuration files, see the Installation and Configuration Guide.
To protect passwords or other information in the configuration
file, use the File Hiding utility (dbfhide) to
obfuscate configuration file contents.
|
-c "keyword=value;
... "
|
Supplies
database connection parameters. If you do not specify the connection
parameters, connection parameters from the SQL CONNECT environment
variable are used, if set. The user ID must have DBA authority or
REMOTE DBA authority. See System Administration Guide: Volume 1 > Connection and Communication Parameters.
|
-l
(lowercase L) file
|
Sends a
live backup of the transaction log to a file. Enables a secondary
system to be brought up rapidly in the event of server failure.
A live backup does not terminate, but continues while the server
runs. It runs until the primary server becomes unavailable. At that
point, it shuts down, but the backed up log file is intact and can
be used to quickly bring up a secondary system.
The live backup of the transaction log is always the same
length or shorter than the active transaction log. When a live backup
is running and another backup restarts the transaction log (dbbackup -x),
the live backup automatically truncates the live backup log and
restarts the live backup at the beginning of the new transaction log.
See System Administration Guide: Volume 1 > Data Backup, Recovery, and Archiving > How to Back Up Databases > Types of Backups > Making a Live Backup of a Transaction Log.
|
-o
|
Writes output messages to the named file.
|
-q
|
Quiet mode — does not display
output messages. This option is available only when you run this utility
from a command prompt.
|
-r
|
Copies
the old transaction log to a new name and starts a new empty log.
The following steps occur:
Sybase IQ copies and saves the current working
transaction log to the directory specified in the command.
Sybase IQ keeps the current transaction log in its
current directory, but renames it using the format yymmddxx.log,
where xx are sequential characters starting
at AA and running to ZZ, and yymmdd represents
the current year, month, and day. This file is then no longer the current
transaction log.
Sybase IQ generates a new transaction log file that
contains no transactions. The new file has the name of the former
current transaction log and becomes the current transaction log.
|
-t
|
Backs up only the transaction log file.
This can be used as an incremental backup since the transaction
log can be applied to the most recently backed up copy of the database
files.
|
-xo filename
|
Truncate
(delete and restart) the transaction log
|
target-directory
|
The directory to which the backup files
are copied. If the directory does not exist, Sybase IQ creates
it. The parent directory must exist.
|