The properties of an SAP HANA database system are defined by the parameters in its configuration files. The configuration files are separated into sections; these sections bundle parameters of the same category.
Opening the System Configuration Tool
You can display and change parameters using the SAP HANA cockpit through the Database Configuration app. To change the parameters of configuration files, you require the system privilege INIFILE ADMIN.
Do not change parameters directly in the configuration files on the operating system level.
Finding Configuration Parameters Using Search
SAP HANA has many configuration files and parameters. Therefore, to find a parameter easily in the parameter structure, use the Search function.
In the Search field, enter the name of a parameter, or few characters of a parameter, and select Enter on your keyboard.
If you upgrade to a new version of SAP HANA, the newest parameter settings based on the newest experiences are included automatically, but your own changes remain unchanged.
You can easily distinguish between parameters that still have their default value or have been changed. The pencil icon beside a parameter is the indicator of a change.
Furthermore, you can take configuration snapshots of the parameters of your database. These snapshots reflect the configuration of a database at the point in time when it was created, and can be compared with the current configuration or another previously generated snapshot. This is an easy way to identify configuration changes over time.
Additionally, the View Change History button shows, when, which, and by whom database parameters were changed in the past.