Hana - System parameters - (System Property|Configuration File|Parameter)
Table of Contents
About
System properties of an SAP HANA system are stored in ini files.
The files are stored in text files on operating system level:
Articles Related
Example
- global system configuration (global.ini)
- service system configuration (for example, indexserver.ini for indexserver).
Structure
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 ']'),
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 |
Management
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 |
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
Edit
Administration editor
You can access and edit configuration files on the Configuration tab of the Administration editor.
ALTER SYSTEM ALTER CONFIGURATION
ALTER SYSTEM ALTER CONFIGURATION
Example:
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'DATABASE', 'MYDB') SET ('memorymanager', 'allocationlimit') = '8192' WITH RECONFIGURE;
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:
- sid
- inst is the instance number