TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

438 Chapter8
Using the Database Utilities
>>PURGE
>>PURGE
Purges the root file and all the data sets of the referenced database. If you use third-party
indexing, the >>PURGE command also purges any existing third-party index files
regardless of third-party indexing being enabled or disabled.
Purging removes the files from the catalog and returns the disk space to the system. As
with >>ERASE, you must be the database creator or must provide the maintenance word to
use DBUTIL with the >>PURGE entry. Before running the DBRESTOR program to restore a
database, use this utility function to purge the database.
If DBUTIL successfully purges the database, it prints a confirmation message on the list file
device.
NOTE The PURGE command purges any associated B-Tree index (.idx) files.
Syntax
>>P[URGE] database name [/ maint word ] [DETACH]
For example:
PURGE ORDERS/SELL
where ORDERS is the database name and SELL is the maint word .
Parameters
database name is the name of a TurboIMAGE/XL database being purged.
maint word is the maintenance word defined by the database creator
when the database is created with DBUTIL. This word
must be supplied by anyone except the database creator
when using DBUTIL to access the database.
DETACH is an option specific to the IMAGE/SQL users. This option
detaches the database from all ALLBASE/SQL database
environments (DBEnvironments) to which it is attached
via IMAGESQL. When DETACH is not used, the database
is purged without detaching from the DBEnvironment(s).
For more information, refer to the IMAGE/SQL
Administration Guide.
Unexpected Results
The following messages are printed if an unexpected situation occurs (refer to appendix A
for other error messages):