PURGEFILE

Purges any DBEFile or DBECon file.

SQLUtil Only

>> PURGEFILE DBEFile Name: DBEFileName Purge DBEFile (y/n)? { Y [es] N [o]}

DBEFileName: is the physical file name of the DBEFile or DBECon file to be purged.

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.

You must be the DBECreator or have SM capability to execute this command.

   >> purgefile

   DBEFile Name:  PartsXF1

   Purge DBEFile (y/n)?  yes



   File purged.

Technical documentation