HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

PURGEALL 

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

Scope 

SQLUtil Only

SQLUtil Syntax 

>> PURGEALL  DBEnvironment Name:  DBEnvironmentName  Purge DBEnvironment

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

DBEnvironmentName       is the name of the DBEnvironment to be purged.

Description 

   *   The PURGEALL command purges an existing DBEnvironment.  When a
       DBEnvironment is purged with this command, the DBECon file, the
       log files, and all DBEFiles related to the DBEnvironment are
       purged.  In order to prevent a user from accidentally purging the
       DBEnvironment, a YES response to the confirmation prompt is
       required.

   *   If you previously purged either the file DBEFile0 or the log
       file(s), the DBEnvironment cannot be purged with the PURGEALL
       command.  In such a case, you would need to use PURGEFILE to
       remove each file separately.

   *   PURGEALL will not purge log files which were in existence prior to
       the most recent START DBE NEWLOG statement.  To remove these log
       files you must use the SQLUtil PURGEFILE command.

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

   *   This command differs from the PURGEDBE command, which does not
       purge log files.

Authorization 

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

Example 

     >> PURGEALL 
     DBEnvironment Name:  PartsDBE 
     Purge DBEnvironment and Log Files (y/n)?  yes 

     DBEnvironment purged.

MPE/iX 5.5 Documentation