Configuring SAP HANA System Properties (INI Files) – by the SAP HANA Academy
Tutorial video
For those interested in SAP HANA system administration and changing system properties, we have updated our tutorial video on this topic for SPS 09 in the SAP HANA Academy, playlist System Administration. In this video, we explain how you can configure the INI files to set and unset SAP HANA system parameters using the SAP HANA studio administration perspective or the SQL console.
As documented, SAP does not recommended changing the default values of parameters unless stated in the documentation or instructed by SAP Support. For more information about frequently used parameters, see SAP Note 2036111. Particularly interesting is the attachment to the note, an excellent resource to the Frequently Used Configuration Parameters in SAP HANA.
More Information
Product documentation
Configuring SAP HANA System Properties (INI Files) is documented in the SAP HANA Administration Guide: Chapter 2, System Administration.
The SQL syntax for changing system parameters is documented in the SAP HANA SQL and System Views Reference: ALTER SYSTEM ALTER CONFIGURATION.
SAP Notes
2036111 – Configuration parameters for the SAP HANA system
Thank you for watching
The SAP HANA Academy provides free online video tutorials for the developers, consultants, partners and customers of SAP HANA.
Topics range from practical how-to instructions on administration, data loading and modeling, and integration with other SAP solutions, to more conceptual projects to help build out new solutions using mobile applications or predictive analysis.
For the full library, see https://blogs.sap.com/2017/01/18/sap-hana-academy-library-by-the-sap-hana-academy/
- Subscribe to our YouTube channel for updates
- Join us on LinkedIn: linkedin.com/in/saphanaacademy
- Follow us on Twitter: @saphanaacademy
- Google+: SAP HANA Academy
- Facebook: facebook.com/saphanaacademy
Thanks for the ℹ !
The information either to restart HDB / not to restart is missing after changing HANA parameter. And there's no way for us to remember what parameter needs to restart to reflect the changes.
Hi Nicholas,
Good point. Wouldn't it be a great feature when HANA would inform you with a pop-up when you modify a parameter that requires a restart? I will forward this as a request to the development team. Who knows? It may be implemented in a feature release.
For now - as mentioned - just check SAP Note 2036111
Here for example are the ones that require a restart for the global.ini file.
==
global.ini
Section: communication
sslCreateSelfSignedCertificate
Section: cryptography
ssfs_key_file_path
Section: inifile_checker
enable
Section: multidb
reserved_instance_numbers
Section: persistence
basepath_datavolumes
basepath_logvolumes
log_mode
savepoint_interval_s
use_mountpoints
==
Yupe, that's definitely something we are looking forward in later & future release. Thanks!