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

PURGEALL

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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.


Feedback to webmaster