HP 3000 Manuals HP 3000 Manuals
HELP
Displays and describes all SQLUtil commands.
Scope
SQLUtil Only
SQLUtil Syntax
>> HELP Command Name (opt): CommandName
Parameters
CommandName is the name of an SQLUtil command.
Description
* If you do not specify a command name, the HELP command lists the
names of all valid SQLUtil commands.
* If a command name is specified, the correct syntax and an
explanation for that command is displayed.
* You must enter // to leave the HELP command.
Example
>> HELP
The following SQLUtil commands are available:
ADDLOG ALTDBE ENDRECOVERY EXIT HELP
MOVEFILE MOVELOG PURGEALL PURGEDBE PURGEFILE
PURGELOG QUIT RECOVERLOG RESCUELOG RESTORE
RESTORELOG SET SETDBEMAINT SETUPRECOVERY SHOWACCESS
SHOWDBE SHOWLOG SHOWSET STORE STORELOG
STOREONLINE ATTACHFILE DETACHFILE STOREINFO CHANGELOG
For more information on any one of the functions, enter the command name
at the prompt. Carriage return <cr> displays a brief description of
each command. Type // to leave SQLUtil HELP.
Command Name (opt): Return
Command Summary:
ADDLOG Adds a new log file to a DBEnvironment.
ALTDBE Changes the startup parameters for a DBEnvironment.
ENDRECOVERY Terminates rollforward recovery procedure.
EXIT Terminates SQLUtil execution.
HELP Displays and describes all SQLUtil commands.
MOVEFILE Moves any DBEFile file across devices.
MOVELOG Moves a log file across devices.
PURGEALL Purges the DBEnvironment and all associated DBEFiles
including the DBELog files.
PURGEDBE Purges an existing DBEnvironment and all associated
DBEFiles except the DBELog files.
PURGEFILE Purges any DBEFile.
PURGELOG Purges a log file from a DBEnvironment.
QUIT Terminates SQLUtil execution.
RECOVERLOG Recovers a log file in rollforward recovery.
RESCUELOG Copies a log file to tape(s) or serial disk(s) when a
database can not be restarted.
RESTORE Copies a DBEnvironment to disk from tape(s) or serial
disk(s) created by using the SQLUtil STORE command.
RESTORELOG Copies a log file to disk from tape(s) or
serial disk(s) created by using the SQLUTIL STORELOG
command.
SET Sets a parameter for a command option. Current parameters
supported are ECHO_ALL, EXIT_ON_DBERR, and BACKUP.
SETDBEMAINT Sets or alters the maintenance word of a DBEnvironment.
SETUPRECOVERY Sets up a DBEnvironment to perform a rollforward recovery.
This is the first step of rollforward recovery.
SHOWACCESS Shows the access mode (mapped or pseudo-mapped) of DBEFiles.
SHOWDBE Shows the information related to a DBEnvironment.
SHOWLOG Shows the information related to log(s) files associated
with a DBEnvironment.
SHOWSET Displays the value of a command option parameter. Current
parameters supported are ECHO_ALL, EXIT_ON_DBERR, and BACKUP.
STORE Copies a DBEnvironment to tape(s).
STORELOG Copies a single log file to tape(s).
STOREONLINE Copies a DBEnvironment to tape(s) ONLINE.[REV BEG]
ATTACHFILE Attaches DBEfileset/DBEfile name with DBEnvironment.
DETACHFILE Detaches DBEfileset/DBEfile name with DBEnvironment.
STOREINFO Displays files stored on a backup device.
CHANGELOG Causes the DBEnvironment to change to the next log file.[REV END]
Command Name (opt): movefile
>> MOVEFILE
DBEnvironment Name: DBEnvironmentName
File Name: FileName
Current Device: CurrentDevice
New Device: [NewDevClass/Number]
Access Mode (mapped) (opt): [FileAccessMode]
Moves DBEFiles, or DBECon files across devices.
Command Name (opt): //
>>