Switching on/off Automatic Extension of the Data Area

You can configure your database system in such a way that it automatically adds a new data volume as soon as the fill level of the data area reaches a certain percentage. To do this you, can switch on automatic extension of the data area using the Database Manager GUI.

Prerequisites

The database instance is in the ONLINE operational state.

A separate event task is required for this function. Ensure therefore that the _MAXEVENTTASKS database parameter is sufficiently large.

If you switch on automatic extension of the data area, the last data volume that you have added must be of the type file.

You can activate automatic extension of the data area when creating a database instance (Creating a Database Instance: Custom).

Switching on Automatic Extension of the Data Area

...

       1.      Choose Instance ® Data Area Extension.

       2.      Enter the filling level at which a new data volume should be added to the data area as a percentage.

       3.      Choose On.

Result

Activating this function enables you to specify a percentage value at which a data volume should be added. If you do not specify a percentage value, the system will add a data volume when the fill level reaches 90%. You can overwrite the defined value by executing the function again using a different value.

The number of data volumes that can be added while the database is in operation is limited by the value of the MAXDATAVOLUMES database parameter.

The system uses existing volume definitions to determine a default name for the new data volume. This name is then used.

Switching off Automatic Extension of the Data Area

...

       1.      Choose Instance ® Data Area Extension.

       2.      Choose Off.

Result

Monitor the database on a regular basis: Displaying Database Information.

Extend the data area in good time (Creating, Displaying and Deleting Volumes) or activate automatic extension of the database again.

See also:

Displaying and Changing Database Parameters

Changing Database Parameters for Volumes