There are multiple tools or approaches can be use to update the HANA parameters. There are also some limitation might be arise from of the listed tools or approaches below. You can read through and choose which approach are suitable for you (it’s like a choosing a shoe :-P)
| APPROACH | DESCRIPTION |
|---|---|
| Parameter file modification | The parameter files are in plain text files which is changeable via text editor. Changes will generally not have an immediate effect which you need to restart SAP HANA. Alternatively there are sometimes implicit reconfigurations within SAP HANA so that a parameter file change can theoretically already get active before a restart is performed. Another option is to use the "-reconfig" option of the hdbnsutil tool: hdbnsutil -reconfig. This command will activate all currently maintained values of online parameters. Immediate Reconfiguration: No |
| SAP HANA Cockpit | From the SAP HANA Cockpit overview of a specific system you can drill down to view various ini files and to add sections to the files.Open "Configure System Properties" by clicking the corresponding DB Administration link in the overview of a single system in SAP HANA Cockpit. Immediate Reconfiguration: Yes SAP Note 2185556 |
| SAP HANA Studio | In SAP HANA Studio you can choose & change or reset SAP HANA parameter values. In the context menu of the file names and sections you have the possibility to add new sections and parameters. Changes are executed with WITH RECONFIGURE so it will immediately take effect (in case of online parameters). Immediate Reconfiguration: Yes SAP Note 2073112 |
| DBACOCKPIT | In DBACOCKPIT you can choose & change or reset SAP HANA parameter values. Changes are executed with WITH RECONFIGURE so it will immediately take effect (in case of online parameters). Immediate Reconfiguration: Yes SAP Note 2222220 |
| ALTER SYSTEM ALTER CONFIGURATION | The ALTER SYSTEM ALTER CONFIGURATION command allows to adjust parameters flexibly. Immediate Reconfiguration: Yes (if WITH RECONFIGURE is used) No (otherwise) |
Reference
2186744 – FAQ: SAP HANA Parameters
