2186744 – FAQ: SAP HANA Parameters

 

1. What is the purpose of SAP HANA parameters?

SAP HANA parameters are configuration options that can be used to influence the behavior of SAP HANA in various ways. Typical reasons for setting parameters are:

  • Individual security settings
  • Workaround for bugs
  • Influencing CPU and memory resource consumption
  • Definition of file and directory locations

Most frequently Used Commands For SAP HANA Administrators

2. Can parameters be set on different layers?

Yes, the scope of a parameter setting can be specified:

  • In all databases of a multitenant environment
  • On all hosts of a SAP HANA database
  • On a specific host of a SAP HANA database

Also see – Top 50 SAP HANA Interview questions and Answers

3. Where can the configured SAP HANA parameters be found?

The configured SAP HANA parameters are stored in text files on operating system level:

File Details
/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>

As an example, the file /usr/sap/C11/HDB01/saphanahost/indexserver.ini contains parameters for the indexserver on host saphanahost.

Leave a Reply