SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
5-3
CLEANUP Operation
CLEANUP Operation
CLEANUP is an OSS command-line utility, run from mxtool, which can remove
damaged objects and orphaned Guardian files when a regular DROP operation fails.
The CLEANUP operation supports the following two modes:
•
CLEANUP of a single damaged object, by object type and ANSI name.
•
CLEANUP of one or more orphaned partitions. An orphaned partition is a Guardian
file which represents an SQL/MX partition that is not associated with any object in
metadata.
object-type
specifies the damaged object for cleanup, and is either TABLE, VIEW, INDEX,
SEQUENCE, or PROCEDURE.
object-name
is the ANSI name of the cleanup object. The name must be fully qualified with the
catalog and schema.
Note. The CLEANUP operation is available only on systems running J06.14 and later J-series
RVUs, and H06.25 and later H-series RVUs.
mxtool CLEANUP { object-option | orphaned-files-opt }
object-option is: object-type object-name options
object-type is:
{ TABLE | VIEW | INDEX | SEQUENCE | PROCEDURE }
object-name is: catalog.schema.object.
options is: [[ -c | -r ][-o=outinfo]]
outinfo is: output-file-name [ CLEAR ]
output-file-name is: an OSS file name
orphaned-files-opt is:
-oo { -f=input-filename | guardian-physical-filename }[ -
o=outinfo ]
input-filename is: an OSS file name generated by VERIFY
operation, which lists the orphaned files in the node.
guardian-physical-filename is:
[\node.]$volume.subvol.filename