sysadmin erssd

Allows you to check ERSSD file locations and backup configurations, or perform an unscheduled backup of the ERSSD.

The command returns the status of ERSSD, including:

ERSSD name
Database file location
Transaction log file location
Transaction mirror location
Backup start time, start date, and intervals
Backup directory location

Syntax

sysadmin erssd [, backup | dbfile_dir, ’path’ | translog_dir, ’path’ |
logmirror_dir, ’path’ | defrag]

Parameters

backup – Performs a single unscheduled backup of the ERSSD.
dbfile_dir, 'path' – Specifies a new directory for the ERSSD database file.
translog_dir, 'path' – Specifies a new directory for the transaction log file.
logmirror_dir, 'path' – Specifies a new directory for the transaction log mirror file.
defrag – Rebuilds the ERSSD database without empty fragments.
path – The pathname of the new directory.
Note: Use these directory path alteration options with caution. Executing sysadmin erssd with these options automatically reboots ERSSD, and may cause system disruption.

Examples

Example 1 – This example shows the output of sysadmin erssd:

sysadmin erssd
---------------------

ERSSD Name  ERSSD Database File   ERSSD Transaction Log
----------  --------------------  ------------------
erssd.db    /dbfile/erssd.db      /log/erssd.log


ERSSD Transaction Log Mirror ERSSD Backup Start Time
---------------------------- ------------------------
/backup/erssd.mlg            2am

ERSSD Backup Start Date   ERSSD Backup Interval
-----------------------   ----------------------
March 20, 2003            12 hours              

ERSSD Backup Location
---------------------
/backup

Usage

Using this command with no options displays the database file path, the transaction log path, the transaction log mirror path, and the start-time, start-date, and location of scheduled transactions.
Using this command with the backup option performs one unscheduled backup.
Using this command with the option dbfile_dir shuts down ERSSD, moves the database to the new directory, updates the Replication Server configuration file, and restarts ERSSD, using the database from the new location.
Using this command with the option translog_dir shuts down ERSSD, moves the transaction log file to the new directory, updates the ERSSD to use the transaction log mirror in the new direcotry, updates the Replication Server configuration file, and restarts ERSSD.
Using this command with the option logmirror_dir shuts down ERSSD, moves the transaction log mirror file to the new directory, updates the ERSSD to use the transaction log mirror in the new directory, updates the Replication Server configuration file, and restarts ERSSD.
Use this command with the option defrag shuts down ERSSD, rebuilds the database file, and restarts ERSSD.
Using this command with the options defrag, dbfile_dir, translog_dir, and logmirror_dir is expensive. During this operation ERSSD is unavailable and all threads that attempt to access it fail. These threads remain blocked until ERSSD is restarted.
Your site version must be 15.0 or above to use defrag. The defragmented file is automatically upgraded to SQL Anywhere 11.0 by this option, and cannot be downgraded after the command is executed.
Use this command when you need to move files to larger, faster disks.
Use single, not double, quotation marks in path.

Permissions

You must have "sa" privileges to execute this command.