HP 3000 Manuals

PURGEDBE [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation


ALLBASE/SQL Database Administration Guide

PURGEDBE 

Purges an existing DBEnvironment--including the DBECon file and all
associated DBEFiles except the log files.

Scope 

SQLUtil Only

SQLUtil Syntax 

>> PURGEDBE  DBEnvironment Name:  DBEnvironmentName  Purge DBEnvironment

(y/n)?  {Y[es]}
        {N[o] }
Parameters 

DBEnvironmentName       is the name of the DBEnvironment to be purged.

Description 

   *   The PURGEDBE command purges an existing DBEnvironment.  When a
       DBEnvironment is purged, the DBECon file and all DBEFiles related
       to the DBEnvironment are purged.  The log files are not purged.

       _________________________________________________________________ 

       NOTE  PURGEDBE does not purge the log files because the log files
             may be used for a subsequent rollforward recovery.  The user
             must use the PURGEFILE command to purge the log file(s).

       _________________________________________________________________ 

   *   In order to prevent a user from accidentally purging the
       DBEnvironment, a YES response to the confirmation prompt is
       required.

   *   This command can only be executed when the DBEnvironment is not in
       use.

   *   If you previously purged either the file DBEFile0 or the log
       file(s), the DBEnvironment cannot be purged with the PURGEDBE
       command.

Authorization 

You must be the DBECreator or have SM capability to use this command.

Example 

     >> purgedbe 
     DBEnvironment Name:  PartsDBE 
     Purge DBEnvironment (y/n)?  yes 

     DBEnvironment purged.



MPE/iX 5.5 Documentation