Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

SAP® MaxDB - Changing Database Parameters

 

This page gives you a short introduction how to change SAP MaxDB database parameters.

Moderator: Birgit Malik

WIKI Space Editor: Thiago Lüttig

Changing Parameters

The database parameter settings are made using database tools (for example: Database Studio or DBMCLI). Changes to some database parameters only become active after restarting the database and apply for the processing of all SQL statements.

Useful Information

As of database version 7.6 you can change some database parameters in operational state ONLINE, without having to stop and restart the database to activate the database parameter change. You can change the database parameter value in operational state ONLINE if attribute CHANGE=RUNNING is set.

Changes to database parameter values with attribute CHANGE=OFFLINE only become valid once the database is restarted.
You can use the DBM command param_getfull and specify the database parameter name to obtain this information (CHANGE=RUNNING/OFFLINE).
Example:
dbmcli -d <database_name> -u <dbm_operator>,<password>
param_getfull OPTIMIZE_FETCH_REVERSE
If database parameters are to be changed in operational state ONLINE, you can perform this change using DBMCLI (Commands for Changing Database Parameters) or Database Studio (Changing Database Parameters).

Example:
dbmcli -d <database_name> -u <dbm_operator>,<password>
param_put -running [-permanent] SHAREDSQL <VALUE>

Option -permanent ensures that the database parameter change is also entered in the parameter file. If this option is omitted, the active database parameter value can deviate from the value in the parameter file. You can read the value that is currently active with the DBM command param_getfull in row ACTIVEVALUE.

 

 

 

 

 

 

 

 

back to top