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-5
CLEANUP Operation
and c.cat_uid = s.cat_uid
and s.schema_name = '<schema>'
and s.schema_uid = o.schema_uid
and o.object_name = '<table name>'
and o.object_type = 'BT'
and d.base_object_uid = o.object_uid;
You can use this query for indexes, replacing <table name> with <index name>
and 'BT' with 'IX'.
A typical output of this query is:
OBJECT_NAME OBJECT_TYPE
---------------------------------------- -----------
EMPLOYEES BT
--- 1 row(s) selected.
>>
In this example, EMPLOYEES is the name of the object. You need to run the
RECOVER utility.
If the query does not return rows, the failed partition operation has rolled back
completely. You do not need to perform recovery.
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.
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.