Chapter 9 Working with Data Models
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 |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |