SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
5-6
CLEANUP Operation
object-type
specifies the damaged object for cleanup, and is either TABLE, VIEW, INDEX, or
PROCEDURE.
object-name
is the ANSI name of the cleanup object. The name must be fully qualified with the
catalog and schema.
options
determines how the CLEANUP operation is performed.
-r restricts the CLEANUP operation for the specified object. If the object has
dependent objects, the CLEANUP operation fails with an error. If no options are
specified, the default is -r.
-c cascades the CLEANUP operation for dependent objects. The dependent
objects are cleaned up along with the specified object.
input-filename
is the OSS file name of a file generated as a result of running the mxtool
VERIFY operation with the -oo option. This file contains the Guardian file
names of orphaned partitions to be removed.
mxtool CLEANUP { object-option | orphaned-files-opt }
object-option is: object-type object-name options
object-type is:
{ TABLE | VIEW | INDEX | 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