Tablespace and Storage Checks (PDM)

PowerDesigner provides default model checks to verify the validity of tablespaces and storages.

Check	Description and Correction
Name and code uniqueness	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
Code maximum length	The code of the tablespace or storage is longer than the maximum allowed by the DBMS. Manual correction: Reduce the length of the code Automatic correction: Reduces the code to a permissible length
Not used	The tablespace or storage you have created is not used in the model. Manual correction: Delete the tablespace or storage or apply it as a physical option to a table, an index, a key, a column, a storage or a view (Options tab of the object property sheet) Automatic correction: None

Check

Description and Correction

Name and code uniqueness

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

Code maximum length

The code of the tablespace or storage is longer than the maximum allowed by the DBMS.

Manual correction: Reduce the length of the code

Automatic correction: Reduces the code to a permissible length

Not used

The tablespace or storage you have created is not used in the model.

Manual correction: Delete the tablespace or storage or apply it as a physical option to a table, an index, a key, a column, a storage or a view (Options tab of the object property sheet)

Automatic correction: None