Show TOC

ParametersLocate this document in the navigation structure

Use

The Administration user menu of the DBA Cockpit contains a display of the current database parameters or SAP liveCache database parameters, and changes to these parameters. You can change database parameters.

Procedure

Open the DBA Cockpit (transaction DBACOCKPIT) and choose Start of the navigation path Administration Next navigation step Parameters End of the navigation path.

Result

The general database parameters are displayed in the simple view.

If you want to display all database parameters, choose Start of the navigation path Goto Next navigation step Expert View End of the navigation path.

If you want to display all database parameters sorted into the groups General Parameters, Extended Parameters, and Support Parameters, choose Start of the navigation path Goto  Next navigation step Group View End of the navigation path.

To display the changes made to a database parameter to date, use one of the methods below:

  • Click on the symbol at the start of the row that contains the parameter.

  • Select the parameter name and choose Expand Subtree.

The system displays a list of the change data and values to which the database parameter was set.

Changing Parameters

If necessary, switch to change mode.

Double-click on a parameter name. You see additional details for that parameter and can change it if necessary. The new database parameter values are checked and saved.

Caution

Changes to database parameters generally do not take effect until the database is restarted.

You can also change some database parameters while the database is running (see the description of individual database parameters for more information). In addition, you can choose how long the change is to be effective for these database parameters:

  • Save: Changes to database parameters do not take effect until the next restart.

  • Activate Temporarily: Changes to database parameters take effect immediately, but only until the next restart.

  • Save and activate: Changes to database parameters take effect immediately and are permanent.

If you change a database parameter whose value is normally calculated by the system, then the set value also remains valid for all subsequent recalculations of database parameter values. The system only recalculates the value when the set value is not within the permitted value range.

Note

You can also use Database Studio or the Database Manager to change database parameters. If you have changed the database parameters with the Database Manager, but these have not yet taken effect, the system may display different parameter values in the CCMS and at operating system level.

More Information

Parameter History

Database Administration, Database Parameters