HPlogo ALLBASE/SQL Database Administration Guide: HP 9000 Computer Systems > Appendix F SQLUtil

HELP

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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 SHOWDBE

       SHOWLOG       SHOWSET        STORE         STORELOG      STOREONLINE

       ATTACHFILE    DETACHFILE     STOREINFO     CHANGELOG     CHKPTHLP



   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.

   



      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.

      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.

      CHKPTHLP       Helps checkpoint command to be done in parallel.



   Command Name (opt): movefile



      >> MOVEFILE

      DBEnvironment Name:  DBEnvironmentName

      Current File Name:  CurrentFileName

      New File Name:  NewFileName



      Moves DBEFiles across devices.



   Command Name (opt):  //

   >>
Feedback to webmaster