Some parameters in SAP HANA database does not require a database restart. Some of them, of course require a restart in order to activate the changes. So, how do you know and differentiate them?
There are 3 methods to determine whether a database restart is required or not.
Method 1
Open the following SAP link, SAP HANA Configuration Parameter Reference: Index
We want to find the “backup” parameter and use the search field button as per below screenshot.
Click on any of the backup parameter below, as an example, catalog_backup_buffer_size.
So, here, you will see whether the parameter changes require restart or not from the Restart required field. The value will be FALSE or TRUE.
Method 2
Open the HANA database SQL editor and use the following command line. Scroll to the right and you will the column of restart required, true or false. Use filtering to ease your findings.
select * from M_CONFIGURATION_PARAMETER_VALUES
Method 3
Login to the operating system level and go to the following directory. Alternatively, use cdexe (then cd config if you use cdexe with sidadm)
/usr/sap/SID/SYS/exe/hdb/config
Open the master ini files.
attributes.ini executor.ini nameserver.ini webdispatcher.ini
compileserver.ini extensions.py preprocessor.ini wlreplayer.ini
computeserver.ini gbaas.ini property_esp.ini xscontroller.ini
daemon.ini global.ini property_generic.ini xsengine.ini
diserver.ini indexserver.ini rsutil.ini xsexecagent.ini
docstore.ini inifiles.ini scriptserver.ini xsuaaserver.ini
dpserver.ini localclient.ini statisticsserver.ini
esserver.ini multidb.ini streamingserver.ini
Example, for backup parameter files, you will see the hints of change offline or online. That will give you the information whether a restart is required or not.
# .short_desc
# Base path for data volumes
# .full_desc
# All data volumes will be stored under this path.
# .type path
# .change offline
basepath_datavolumes=$(DIR_GLOBAL)/hdb/data
# .short_desc
# Base path for log volumes
# .full_desc
# All log volumes will be stored under this path.
#
# \see \ref logger
# .type path
# .change offline
basepath_logvolumes=$(DIR_GLOBAL)/hdb/log
Reference
- 2856122 – How to check if system restart required after modifying a parameter
- https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.05/en-US/0eff3c0e8970497c9973d828f08d40c2.html
- 2530688 – Which HANA parameter needs to be configured online or offline
