TurboIMAGE/XL Database Management System Reference Manual (30391-90012)

442 Chapter8
Using the Database Utilities
>>PURGE
Example
:RUN DBUTIL.PUB.SYS Initiate DBUTIL execution.
.
.
.
>>PURGE ORDERS Enter >>PURGE command and database name assuming there is
no maintenance word.
The next messages are returned if you are using IMAGE/SQL, and the DETACH option is
used with the >>PURGE command.
Database has been detached from these HP SQL DBEnvironments:
DBEname.group.account
DBEname.group.account
Database has been PURGED
DBUTIL confirms that the user is logged on with the same user name, account, and group
which were used to create the database. It then determines whether the root file exists and
if so, purges the root file and any files named ORDERS01, ORDERS02, and so forth. Even
if the root file does not exist, any data sets with file names based on the root file name are
purged.
If user runs DBUTIL in interactive mode, DBUTIL will prompt the database name
Message Meaning
No root file, >>PURGE
operation proceeding
DBUTIL was unable to locate the root file, but will attempt to
purge data set, if any.
Data set XXXXk has
been purged
DBUTIL successfully purged the root file and the n data sets of
the database. However, DBUTIL also discovered and purged an
unexpected data set named XXXXk, where k is a number
greater than the number of data sets defined for the database
(n).
Data set XXXXk is
missing
DBUTIL successfully purged the root file and all existing data
sets but data set XXXXk is unexpectedly missing. In this case k
is less than the number of data sets defined for the database.
Incomplete purge An error occurred while DBUTIL was attempting to purge the
database and any Third-party indexing files. The specific error
message is printed above this one. Some of the data sets and, if
applicable, index files have been purged.
Detach failed from
DBEname
This message is returned if you are using IMAGE/SQL. DBUTIL
was unable to detach the TurboIMAGE/XL database from the
ALLBASE/SQL database environment (DBEnvironment) to
which it was attached. However, DBUTIL will continue executing
the >>PURGE command. For more information, refer to the
IMAGE/SQL Administration Guide.