Show TOC

 Displaying and Maintaining the Storage ParametersLocate this document in the navigation structure

Procedure
  1. Open the Repository Browser and navigate to the required table.
  2. Open the table in display mode by double-clicking it.
  3. Choose Utilities → Database Object → Database Utility.

    The Utility for database tables screen appears.

  4. To display the storage parameters that are currently valid for the table and its indexes, choose Storage Parameters.
    Note

    The parameters displayed here depend on the database system used. To find information about the meaning of the displayed parameters, select the parameter and press F1.

  5. Choose  with the quick info text Display<->Change.

    You can now enter values for the changeable parameters.

    Caution

    You can change only some storage parameters directly.

  6. Make your changes and choose Apply.

    The changed settings are now active in the database.

    Tip

    For example, if you change the next extent size directly, the next table extent is created with the new size. This change has no effect on existing extents.

    The table space in which the table lies cannot be changed directly. Such a change requires you to delete the table in the old table space and create a new one in the new tablespace.

  7. To display which storage parameters would be computed from the current values of the technical settings, choose Technical settings.

    You can also explicitly define which storage parameters must be used next time the table or an index of the table is created. For example, this may be necessary if you changed the technical settings of the table and want to make sure that these changed settings are used when the table is converted.

    To do this, proceed as follows:

    1. Choose For new creation.
    2. On the following screen, you can create a template for the parameters.

      You can decide here if you want to use one of the following as a template:

      • The storage parameters currently valid in the database (Current database parameters)
      • The storage parameters computed from the technical settings (Computed from the technical settings)
      • The non-valuated default values of the database system (Database default values)
      • The parameters of another table (Database parameters from the table)
  8. Choose  with the quick info text Copy.
  9. Maintain all the parameters and enter the required values.
  10. Save your entries.

    If you create the table again in the database (for example, during a conversion), the system uses the parameters that you have entered.