Storage Parameters

Use

Storage parameters can be set for database tables (transparent tables, table pools, table clusters, pooled tables, and cluster tables). These parameters affect the way in which tables are handled in the database. For example, the storage parameter defines the table space in which the table must be created in the database and the size to be selected for the table extents.

Note

The existing storage parameters and the settings that are allowed depend on the database system in use. To find out which parameters can be set in your database system, consult the system documentation for your database system.

Effective Storage Parameters for a Table

When a table is activated for the first time, the system computes the storage parameters for the table from the technical settings of the table and then creates it in the database with these storage parameters. If there are no technical settings, the default values of the database system are used.

If the table is deleted from the database and created again at a later time (for example, due to a table conversion ), the storage parameters to be used are defined in a fixed hierarchy.

If there are user-defined storage parameters, these are used. If there are no user-defined storage parameters, the valid parameters used previously in the database are used. If there are no such parameters either (for example, if the table was previously a pooled or cluster table that was converted to a transparent table by conversion), the system computes the storage parameters from the technical settings. If there are no technical settings for the table either, the default values of the database system are used.

Caution

If the technical settings of a table that already exists in the database are changed and activated, the valid storage parameters for the table in the database are not changed. In this case you must change the valid storage parameters manually with the database utility.