Entering content frame

Procedure documentationDisplaying the Data for All Database Parameters Locate the document in its SAP Library structure

Use

You request all the database parameters from the default parameter file and the parameter file of the database instance.

The reply contains the name of each database parameter, its data type, and its current value. This is the value that is copied from the parameter file at the start of the session. If the parameter is not in the parameter file, the value from the default parameter file is displayed.

By specifying properties, you can limit what is displayed. However, you can specify each property only once. If the same property is entered more than once, the value of the last entry is used.

A parameter must match the relevant value in all the specified properties (AND link). Several values for one property separated by commas are treated as an OR link.

See also:

Properties of Database Parameters

Prerequisites

You have the server authorization ParamRead.

Syntax

param_extgetall [<property>=<value>]

Options

Option

Description

<property>

Property of the parameter

<value>

Value of the property

Reply

OK<NL>
<
parameter_name> <type> <value><NL>
<
parameter_name> <type> <value><NL>
...

Values for the Reply Fields

Value

Description

<parameter_name>

Name of the parameter

<type>

Data type of the parameter

<value>

Value of the parameter

 

In the event of errors, see Reply Format.

Example

Logging on to the Database Manager CLI as operator DBM with password DBM, connecting to the HOTELDB database instance, displaying all the parameters that cannot be changed and are assigned to the General – General Database Parameters group

dbmcli –u DBM,DBM –d HOTELDB param_extgetall CHANGE=NO GROUP=GENERAL

OK

KERNELVERSION                           string  KERNEL    7.6.00   BUILD 001-103

-076-482

INSTANCE_TYPE                           string  OLTP

 

Leaving content frame