Procedure documentation Opening the Database Parameter History Locate the document in its SAP Library structure

Use

You open the Structure linkdatabase parameter history and transfer the first block of the contents. The entries are output in reverse chronological sequence, that is, starting with the most recent and ending with the oldest.

You can limit the output by specifying options. If you enter several selection criteria, then only those parameter changes that correspond to all the criteria are output.

If the parameter history entries have been incompletely transferred, you can call up the rest of the contents using the command for scrolling through the database parameter history.

Prerequisites

You have the DBM operator authorization ParamRead.

Syntax

param_gethistory [fields=<field_list>] [name=<parameter_name>] [date=<yyyymmdd>] [group=<group_list>] [state=<state_list>]

Example

Options

<field_list>

You can restrict the quantity of history fields supplied by the Database Manager by specifying a field list.
Enter the fields that you want output here using a comma as a separator.
The fields you select will always be output in the following sequence:

Possible entries:

DATE Date when the parameter was changed (YYYYMMDD)
TIME Time when the parameter was changed (00HHMMSS)
NAME Parameter name
NEWVALUE New value of the parameter
OLDVALUE Old value of the parameter
STATE The change status of the parameter
GROUP Group to which the parameter is assigned

If you do not specify a field list, then all fields will be output.

<parameter_name>

You can display the history of one specific parameter by specifying the parameter name.
If you do not specify a parameter name, the entries for all parameters in the history are displayed.

<yyyymmdd>

If you specify a date, then only those parameter changes that have taken place since this date will be output.
If you do not specify a date, all entries in the history are supplied.

<group_list>

You can restrict the database parameters for which the changes are displayed by specifying a parameter group. Use a comma to separate entries.

Possible specifications are:
GENERAL: Structure linkGeneral Database Parameters
EXTENDED: Structure linkSpecial Database Parameters
SUPPORT: Structure linkSupport Database Parameters

If you do not specify a parameter group, then the parameter changes for all groups will be output.

<state_list>

You can specify the change state to determine whether active, changed or deleted database parameters should be output. Use a comma to separate entries.

Possible entries are: A (active), C (changed), D (deleted)

if you do not specify a state, then all parameter changes will be output.

Reply

OK
<header_line><NL>
<param_line><NL>
<param_line><NL>
...

Values for the individual fields of the reply

<header_line>

Contains the names of the fields displayed
S stands for STATE and describes the parameter's status

<param_line>

Contains the values for the fields described in the <header_line>, the values are in the same column position as the field description in the <header_line>

Field S for STATE (change status of the database parameters) can contain any of the following entries:

c: changed
d: deleted
a: active