SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-22
Considerations—CLEANUP
If you omit the exclamation point when you use CLEANUP interactively, this
prompts normally appear:
DO YOU WISH TO CLEANUP THE ENTIRE FILESET
... (name of fileset) ...
(Y[ES], N[ONE], S[ELECT], F[ILES])?
If you allow CLEANUP to prompt, use one of these responses:
[NO] CATALOG[S]
specifies whether to delete catalog tables and associated indexes in addition to
other objects and programs specified in qualified-fileset-list.
To purge catalog tables and indexes, you must specify CATALOG[S] and you must
use the wild-card character (*) in the qualified-fileset-list to indicate all
catalog tables and indexes in the catalog. (CLEANUP can purge only entire
catalogs, not individual catalog tables or indexes within a catalog.)
If you omit CATALOG[S] or specify NO CATALOG[S], CLEANUP deletes only
objects that are not part of a catalog.
SHADOWSONLY
directs SQL to delete shadow labels for objects in qualified-fileset-list,
but not the objects themselves. If you omit SHADOWSONLY, CLEANUP does not
purge shadow labels. (Shadow labels—temporary internal labels created when
objects are dropped from the node—are discussed in the SQL/MP Installation and
Management Guide.)
You cannot specify SHADOWSONLY and CATALOGS in the same CLEANUP
command.
Considerations—CLEANUP

Only the local super ID can use CLEANUP. To delete damaged objects on multiple
nodes, the super ID on each node must run CLEANUP for that node.

After deleting each object, CLEANUP displays a message indicating the object and
catalog entry that was deleted.

You cannot use CLEANUP within a user-defined TMF transaction.
SQL automatically starts a transaction for each catalog description and file label
purged with CLEANUP, so only the deletion of the last SQL object (or partition) is
undone if CLEANUP fails before the deletion is committed.
Y[ES] Purge the whole set
N[ONE] Cancel the command
S[ELECT] Prompt object-by-object
F[ILES] List objects in fileset