Procedure documentationParameters Locate this document in the navigation structure

 

The Configuration user menu contains, among other things, a display of the current database/SAP liveCache parameters and changes to these parameters. You can change database parameters.

Prerequisites

Prerequisites

SAP liveCache Technology: In accordance with the Authorization Concept, the user was assigned one of the roles SAP_BC_LVC_ADMINISTRATOR or SAP_BC_LVC_SUPERUSER.

Procedure

Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10). Choose   Administration   Configuration   Parameters  .

or

Open the DBA Cockpit (transaction DBACOCKPIT) and select   Administration   Parameters  .

Result

The general database parameters are displayed in the simple view.

If you want to display all database parameters, choose   Goto   Expert View  .

Choose   Goto   Group View   if you want to display all database parameters sorted into the groups General Parameters, Extended Parameters, and Support Parameters.

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

  • Click the icon at the start of the row that contains the database 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 Database Parameters

If necessary, switch to change mode.

Double-click 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 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.

End of the caution.

Note Note

You can also change the database parameters with Database Studio/Database Manager. Different parameter values can be displayed in the CCMS and at operating system level if you have changed the database parameters with the Database Studio/Database Manager, but these changes have not yet taken effect.

End of the note.

More Information

DBA Cockpit: SAP MaxDB, Parameters

Database Administration, Database Parameters