HPlogo ALLBASE/SQL Database Administration Guide: HP 3000 MPE/iX 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 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.

      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.







   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):  //

   >>


Feedback to webmaster