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-8

Restrictions

system schema. If no information exists for the partition's schema, then the

partition is considered orphaned.



If catalog and schema information for the partition's catalog and schema exists,

then object information must be present in the OBJECTS table in the

DEFINITION_SCHEMA_VERSION_nnnn schema for the partition's catalog. If

no information exists for the partition's object, then the partition is considered

orphaned.



If one or more of the metadata tables mentioned above are not available at the

time of cleanup, then it cannot be determined if the partition is orphaned. In this

case, the partition is not cleaned up.

Restrictions



You cannot perform the CLEANUP operation on a schema or a catalog.



You cannot perform the CLEANUP operation to remove a system metadata object

by object name. However, you can remove orphaned partitions from system

metadata objects.

Examples

The following example performs cleanup of a table with a dangling partition reference.

The log file name is not specified and the CLEANUP operation generates a default log

file, LOG_Wed_Jun_27_00_35_20_2012.

>> mxtool cleanup catalog.schema.sometable

Hewlett-Packard NonStop(TM) SQL/MX MXTOOL Utility 3.2

Log file containing results of the operation: LOG_Wed_Jun_27_00_35_20_2012

cat LOG_Wed_Jun_27_00_35_20_2012

*************** Time: <time> Process: <process> Log opened ***************

Cleanup of Table CAT.SCH.SOMETABLE -- Operation Started.

\COBOLT.$DATA01.ZSDR4XG7.FG5BNL01: error returned 11

Table: CAT.SCH.SOMETABLE

Cleanup of Table CAT.SCH.SOMETABLE -- Operation Finished.

Note. The date-time prefix of each log line has been omitted for brevity.