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

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

721

722

723

724

725

726

727

728

729

730

SQL/MX Utilities

HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005

5-5

Restrictions

Schema information for the object's schema in the SCHEMATA table in the

system schema

Object information in the OBJECTS table in the

DEFINITION_SCHEMA_VERSION_nnnn schema in the object's catalog

•

The cleanup of orphaned partitions requires the metadata to be available to

determine if the partitions are orphaned. For each partition to be cleaned up, the

following information must be available:

Catalog information for the partition's catalog must be present in the CATSYS

and CAT_REFERENCES tables in the system schema. If no information exists

for the partition's catalog, then the partition is considered orphaned.

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

for the partition's schema must be present in the SCHEMATA table in the

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.