Horizontal Partitioning Checks (PDM)

The following PDM model checks are made on horizontal partitioning objects:

Check

Description and Correction

Horizontal partitioning name and code uniqueness

Horizontal partitioning names and codes must be unique in the model.

Manual correction: Modify the duplicate name/code

Automatic correction: Appends a number to the duplicate name/code

Existence of partition

A horizontal partitioning object cannot be empty, it must contain at least one partition.

Manual correction: Delete the horizontal partitioning object or create at least one partition in the horizontal partitioning object property sheet

Automatic correction: Deletes empty horizontal partitioning object

Unavailable target table

A partition should have a corresponding table. You could delete a table that actually corresponds to a partition, this check verifies that each partition has a corresponding table.

Manual correction: Delete the partition with no corresponding table

Automatic correction: Deletes the partition with no corresponding table


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com