Show TOC

param_putLocate this document in the navigation structure

Use

With this command you can change database parameter values. If you execute this DBM command, the system implicitly opens a parameter session. The parameter value is changed and checked against the properties, calculation formulas, and conditions stored in the default parameter file. The change to the parameter is then confirmed and entered into the parameter file.

The system rejects the change of the parameter if the specified value or changing the parameter is impermissible due to the parameter properties.

You have the option of defining how long the change is effective:

  • Until the next restart

  • After the next restart only

  • Immediately and permanently

However, changes effective until the next restart can only be defined for database parameters, which have the property CHANGE=RUNNING.

Prerequisites

You have the server permission ParamCheckWrite.

Structure

param_put [-running] [-permanent] <parameter_name> <new_value> [<comment>]

Option

Description

[-running] [-permanent]

Permanence of the change

Possible values are: -running | -permanent | -running -permanent

-running: The change is valid immediately but only lasts until the database is next transferred into the OFFLINE operational state, in other words, until the database is next restarted or transferred to the operational state ADMIN. Afterwards the parameter reverts to its original value.

-permanent: The change is only made in the database parameter file. It is not effective immediately. It only becomes effective when the database is restarted (system default).

-running -permanent: The change is effective immediately and persists after a restart.

<parameter_name>

Name of the database parameter

<new_value>

New parameter value

<comment>

Comment stored for the database parameter

If the comment line contains spaces, put the line in double quotation marks.

Result

OK

In the event of errors, see Reply Format.

More Information

param_getproperties

param_directput (only if requested by SAP Support)

Commands for Changing Database Parameters

Database Administration, Database Parameters