PURGEFILE [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
PURGEFILE
Purges any DBEFile or DBECon file.
Scope
SQLUtil Only
SQLUtil Syntax
>> PURGEFILE DBEFile Name: DBEFileName Purge DBEFile (y/n)? {Y[es]}
{N[o] }
Parameters
DBEFileName is the physical file name of the DBEFile or
DBECon file to be purged.
Description
* The PURGEFILE command can be used to purge any DBEFile or DBECon
file. The file will not be purged if it is in use.
* PURGEFILE should be used after using START DBE NEWLOG to purge any
log files that existed prior to issuing the START DBE NEWLOG
statement.
* After completing the ENDRECOVERY step of partial rollforward
recovery, PURGEFILE should be used to purge the group which
contained the temporary DBEnvironment of all log files used for
the partial rollforward recovery process.
* Do not use PURGEFILE to try to purge a log file following a
STORELOG command. Be sure to use PURGELOG instead.
_________________________________________________________________
WARNING The DROP DBEFILE command automatically removes the
physical file associated with the DBEFile when it
executes. Therefore, you should not purge the physical
file associated with a DBEFile before using the DROP
DBEFILE statement. If you do, an entry for the physical
file which you will not be able to remove will still
remain in the system catalog even though the physical
file no longer exists.
_________________________________________________________________
* If you purged either the file DBEFile0 or the log file(s), you
will not be able to purge the DBEnvironment using PURGEDBE.
Authorization
You must be the DBECreator or have SM capability to execute this command.
Example
>> purgefile
DBEFile Name: PartsXF1
Purge DBEFile (y/n)? yes
File purged.
MPE/iX 5.5 Documentation