You can set physical options for selected objects to override the default physical options.
For more information about default physical options (see Defining default physical options).
There are two different interfaces for specifying physical options for individual objects, both of which are accessible through tabs on the object's property sheet:
Physical Options (Common) – this tab is displayed by default (along with the Partition tab, if applicable), and lists the most commonly-used physical options in the format of a standard property sheet tab. You can enter values for the necessary option parameters and click OK
Physical Options (All) – this tab is hidden by default, and lists all the available physical options for the object in a tree format. To display this tab, click the Property Sheet Menu button and select Customize Favorite Defining default physical options, to modify the appropriate options.
. You should follow the procedure inChanges made on either of these tabs will be reflected on the other.
You can choose a tablespace or storage already defined in the model as a value for a tablespace or storage that you define for a table. These are listed in a list below the right pane in the Options tab. In DB2 OS/390, tablespaces are, by default, prefixed by the name of the database attached to the model (see DBMS-Specific Features). For more information on defining tablespaces and storages, see Generating a Database from a PDM.