sysadmin erssd

Description

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:

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

Removes fragments from the database file.

path

The pathname of the new directory.

NoteUse 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

Permissions

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