In this page you will be learning how to configure the Sap Hana system. You will find sap hana configuration step procedures via Hana studio as well as hana system configuration via SQL syntaxes.
You can set parameters either via Hana Studio or via SQL syntaxes. Hana studio is very handy to perform parameters update on the fly, however SQL scripts should be privileged when temporary parameter changes is concerned. For instance, part of an overall batch procedure, you may want to stop the database logging mode before uploading data into a tables. Using a SQL script will not only help to stop the logging mode automatically, it will also put it back at the end of the procedure. Forgetting to reset a parameter is unlikely to happen in that case.
What are sap hana parameter files directories?
Sap hana parameters are stored into various parameter files. Files are situated in specific directories depending of whether it is in regard to a tenant database or to the global system environment.
Configuration files are created in the following default directories:
The whole system configuration files are located in :
/hana/shared/< SID >/global/hdb/custom/config : this is for the SYSTEMDB. It covers the entire system environment, tenants included.
Individual database configuration is located in :
/hana/shared/< SID >/global/hdb/custom/config/DB_< Database name > : this is for a specific tenant database
There are few SAP HANA system configuration files (*.ini ). Some hana configuration files will concerne the entire sap hana system where as other will be for a specific tenant database
Example : for global settings
-rw-r--r-- 1 haqadm sapsys 525 Jan 10 17:25 global.ini
-rw-rw-r-- 1 haqadm sapsys 33 Sep 6 10:08 indexserver.ini
-rw-r--r-- 1 haqadm sapsys 423 Feb 18 17:09 nameserver.ini
-rw-r--r-- 1 haqadm sapsys 25 Oct 4 16:48 daemon.ini
drwxr-x--x 2 haqadm sapsys 64 Nov 28 13:53 DB_QBW
drwxr-x--x 2 haqadm sapsys 47 Sep 6 10:21 DB_QHB
drwxr-x--x 2 haqadm sapsys 64 Jan 23 14:59 DB_QTB
drwxr-x--x 2 haqadm sapsys 47 Jan 10 17:25 DB_VBW
-rw-rw-r-- 1 haqadm sapsys 7408 Sep 6 10:07 hdbconfiguration_1
-rw-rw-r-- 1 haqadm sapsys 7408 Sep 6 10:46 hdbconfiguration_2
drwxr-x--- 3 haqadm sapsys 4096 Sep 6 10:45 lexicon
-rw-r--r-- 1 haqadm sapsys 42 Feb 18 17:18 webdispatcher.ini
-rw-rw-r-- 1 haqadm sapsys 64 Sep 6 10:08 xsengine.ini
Example : for specific tenant database settings 'QBW'
-rw-r--r-- 1 haqadm sapsys 97 Nov 28 13:53 global.ini
-rw-r--r-- 1 haqadm sapsys 255 Oct 26 11:03 indexserver.ini
-rw-r--r-- 1 haqadm sapsys 29 Oct 20 11:08 xsengine.ini
How to update sap hana parameters?
How to Update database parameter using SQL command?
How to update sap hana "log mode" parameters?
Update log mode parameter
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('persistence', 'log_mode') = 'normal' WITH RECONFIGURE;
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('persistence', 'log_mode') = 'overwrite' WITH RECONFIGURE;
How to update sap hana "automatic log backup" parameters?
Change Automatic Log Backup
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('persistence', 'enable_auto_log_backup') = 'yes' WITH RECONFIGURE;
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('persistence', 'enable_auto_log_backup') = 'no' WITH RECONFIGURE;
How to show database parameter values in sap hana?
How to Show database parameter using sap hana SQL query
How to check sap hana backup parameter value?
How to configure sap hana for backup and point in time recovery?
Apart from defining backup directories, there are 2 important configuration to consider :
● Sap hana configuration for total recovery :
Hana backup configuration allows data recovery up to the last moment of a crash. It is also called point in time hana recovery. This configuration is recommended in order to garantee a full hana database recovery to a point in time.
● Sap hana configuration for partial recovery :
It allows a basic recovery from the last sap hana "savepoint". In other words it is a sap hana recovery from the last complete data backup.
What are sap hana log mode values?
Log mode values in Sap Hana are : < overwrite >, < normal > or < legacy >.
There is also a value of "default" which is another way to set to < normal >.
You would alter the hana log mode parameter using Hana Studio administration console or via SQL Command.
Hana log mode setting has the following impact :
● Log mode < overwrite > re-used log segments therefore Hana data recovery content is lost. On the other hand, there is no disk space monitoring to worry about. There is no log backup performed in that mode. In other words, there is no possible point in time recovery. The log mode < overwrite > should never be set in a hana production environment.
● Hana log mode < normal > secure individual segment from data to be overwritten. New hana log segments are created as needed until the log segments are backed up. A disk full event will occur when hana log backup are not performed. In order to activate hana log backup the Automatic log backup parameter has to be activated.
Therefore Hana log mode parameter set to < normal > is to be associated with the hana parameter < enable_auto_log_backup > set to "Yes" in order to garantee log being backed up and a point in time recovery.