We many times need to know whether a hana parameter is dynamic or a restart is required to make it effective. To check this goto below

• open cdexe on the OS side, if you already configured this alias
• otherwise go to the folder “cd /usr/sap/$SAPSYSTEMNAME/SYS/exe/hdb”
• open the config folder by command “cd config”
• open the Master ini files you need with the editor (do not adjust value in these files)
• check the hint for the parameter you are looking for, there you will find configure online or offline

Example

Below files contains details about

• Default values (not to be adjusted)
  • /usr/sap/<sid>/HDB<inst>/exe/config
  • /hana/shared/<sid>/HDB<inst>/exe/config
• Valid for a specific service (e.g. indexserver) or component (e.g. multidb) on all hosts
  • /usr/sap/<sid>/SYS/global/hdb/custom/config/<service_or_component>.ini
  • /hana/shared/global/hdb/custom/config/<service_or_component>.ini
• Valid for all services on all hosts
  • /usr/sap/<sid>/SYS/global/hdb/custom/config/global.ini
  • /hana/shared/<sid>/global/hdb/custom/config/global.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>/<service_or_component>.ini
  • /hana/shared/HDB<inst>/<host>/<service_or_component>.ini
• Valid for all services on a specific host <host>
  • /usr/sap/<sid>/HDB<inst>/<host>/global.ini
  • /hana/shared/<sid>/HDB<inst>/<host>/global.ini