Procedure documentation Defining Volume Parameters Locate the document in its SAP Library structure

Use

You define the maximum possible number of volumes for a database instance using the relevant Structure linkdatabase parameters.

Volume Type

Parameter

Structure linkData Volume

MAXDATAVOLUMES

Structure linkLog Volume

MAXARCHIVELOGS

You can change the settings of both parameters at a later date regardless of which Structure linkoperational state the database instance is in. Like all parameter changes, these changes take effect the next time the database instance is restarted.

Procedure

  1. First, follow the procedure described in Displaying and Changing Current Database Parameters.
  2. Then transfer the database instance to the ADMIN operational state.
  3. Restart the database instance.
    The Database Manager GUI transfers the database instance first into OFFLINE operational state and then into ONLINE operational state and saves the new value in the parameter file. It reserves the amount of memory space required for this number plus a reserve equal in size to the largest volume of this type. This reserve allows you to create an additional volume of this type while the database is running if the number originally planned is insufficient.

Note

How to create volumes is described in Defining Volumes.