HPlogo ALLBASE/SQL Database Administration Guide: HP 3000 MPE/iX Computer Systems > Appendix F SQLUtil

PURGEDBE

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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.


Feedback to webmaster