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