Hana - System parameters - (System Property|Configuration File|Parameter)

1 - About

System properties of an SAP HANA system are stored in ini files.

The files are stored in text files on operating system level:

3 - Example

  • global system configuration (global.ini)
  • service system configuration (for example, indexserver.ini for indexserver).

4 - Structure

4.1 - Section

Configuration files are separated into sections; sections bundle properties of the same category.

The parameter file content is organized via sections. The section names are put into brackets ('[' and ']'),

4.2 - Layers (Scope)

Properties can be configured at different levels or layers depending on the configuration file.

Layer Priority (Order of precedence) Description
Default 3 The default value for the property
System 2
Host 1 The host-specific value for the property

5 - Management

5.1 - Possible (Layer|Scope) by properties

The M_INIFILES system views shows the layers on which the properties of each configuration file can be configured.

N FILE_NAME DEFAULT_LAYER SYSTEM_LAYER DATABASE_LAYER HOST_LAYER
1 attributes.ini TRUE FALSE FALSE FALSE
2 compileserver.ini TRUE FALSE FALSE FALSE
3 daemon.ini TRUE FALSE FALSE TRUE
4 dpserver.ini TRUE FALSE FALSE FALSE
5 esserver.ini TRUE FALSE FALSE FALSE
6 executor.ini TRUE FALSE FALSE FALSE
7 extensions.ini TRUE FALSE FALSE FALSE
8 global.ini TRUE TRUE FALSE FALSE
9 indexserver.ini TRUE TRUE FALSE FALSE
10 localclient.ini TRUE FALSE FALSE FALSE
11 multidb.ini TRUE FALSE FALSE FALSE
12 nameserver.ini TRUE TRUE FALSE FALSE
13 preprocessor.ini TRUE FALSE FALSE FALSE
14 property_db2.ini TRUE FALSE FALSE FALSE
15 property_esp.ini TRUE FALSE FALSE FALSE
16 property_maxdb.ini TRUE FALSE FALSE FALSE
17 property_mss.ini TRUE FALSE FALSE FALSE
18 property_ntz.ini TRUE FALSE FALSE FALSE
19 property_orcl.ini TRUE FALSE FALSE FALSE
20 rsutil.ini TRUE FALSE FALSE FALSE
21 scriptserver.ini TRUE FALSE FALSE FALSE
22 statisticsserver.ini TRUE TRUE FALSE FALSE
23 webdispatcher.ini TRUE FALSE FALSE FALSE
24 xsengine.ini TRUE FALSE FALSE FALSE

5.2 - List

System view Description
M_INIFILE_CONTENTS actual values configured for the properties of each file and on which layers.

select * from M_INIFILE_CONTENTS

5.3 - Edit

5.3.1 - Administration editor

You can access and edit configuration files on the Configuration tab of the Administration editor.

5.3.2 - ALTER SYSTEM ALTER CONFIGURATION

ALTER SYSTEM ALTER CONFIGURATION

Example:


ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'DATABASE', 'MYDB') SET ('memorymanager', 'allocationlimit') = '8192' WITH RECONFIGURE;

5.4 - Location

The ini files are stored at the following default location on the server: /hana/shared/$SID/global/hdb/custom/config.

File Details
/usr/sap/<sid>/HDB<inst>/exe/config Default values (not to be adjusted)
/usr/sap/<sid>/SYS/global/hdb/custom/config/<service_or_component>.ini Valid for a specific service (e.g. indexserver) or component (e.g. multidb) on all hosts
/usr/sap/<sid>/SYS/global/hdb/custom/config/global.ini Valid for all services on all hosts
/usr/sap/<sid>/HDB<inst>/<host>/<service_or_component>.ini Valid for a specific service (e.g. indexserver) or component (e.g. multidb) on a specific host <host>
/usr/sap/<sid>/HDB<inst>/<host>/global.ini Valid for all services on a specific host <host>

where:

6 - Documentation / Reference


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap