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

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

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

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

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 ']'),

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

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

select * from M_INIFILE_CONTENTS

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

ALTER SYSTEM ALTER CONFIGURATION

Example:

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

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

where:

• sid
• inst is the instance number

• Configuring SAP HANA System Properties (INI Files)
• SAP HANA Server Installation and Update Guide - Parameter Reference
• SAP HANA Administration Guide - Change a System Property
• 2186744 - FAQ: SAP HANA Parameters