Chapter 10 Generating a Database from a PDM

Defining tablespace and storage

The lists of tablespace and storage options offer pre-defined parameters for each DBMS where applicable. The lists show default values and value lists for certain parameters which correspond to the recommended values for the DBMS.

For more information on tablespace and storage options for a particular DBMS, see its reference manual.

Steps To define tablespace and storage:

  1. Select Model→Tablespaces.

    or

    Select Model→Storages.

    The List of Tablespaces or List of Storages appears.

    Note   Tablespace or storage not applicable
    When tablespace or storage options are not applicable for a DBMS, the corresponding Database menu item is grayed.

  2. Click a blank line in the list.

    or

    Click the Add a Row tool.

    An arrow appears at the beginning of the line.
  3. Type a Tablespace name and tablespace code.

    or

    Type a Storage name and storage code.
  4. Click the Properties tool.

    A message requesting if you want to commit all changes appears.
  5. Click Yes.

    The Tablespace or Storage properties sheet opens to the General page.
  6. Click the Physical Options tab.

    Note   Simplified Physical Option tabs
    PowerDesigner offers simplified physical option tabs for some DBMSs. Consequently you may have the option of choosing between the Physical Options (Common) and Physical Options (All) tabs.



    The Physical Options tab appears. The Syntax tabbed page in the left pane lists the database options available for a tablespace or storage. These options are DBMS specific, and not all DBMS support options for tablespaces and storages.
  7. Select an option from the Syntax tabbed page.
  8. Click the >> button.

    The name of the option appears as an item in the Items tabbed page.
  9. Select the item from the Items tabbed page.

    The option name appears with an equals sign next to a textbox at the bottom of the dialog box. Depending on the type of value the option can take, a dropdown listbox can appear instead of a textbox.
  10. Type a value for the option in the textbox below the right pane

    or

    Select a value from the dropdown listbox below the right pane.
  11. If you want to include more options in the tablespace or storage definition, select other options and type or select their parameter values.
  12. Click OK.

    The selected options appear in Options column of the List of Tablespaces or List of Storages.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.