How to switch hana log_mode to overwrite

 How to switch hana log_mode to overwrite


Myth - Needs DB restart
Reality - It is a Dynamic parameter , doesn't need DB restart

How to do it:

- Using sql command:
ALTER SYSTEM ALTER CONFIGURATION ('global.ini','SYSTEM') set ('persistence','log_mode')='overwrite' with reconfigure;

OR

-By changing config parameter from hana studio
switch to configuration tab
in global.ini, search parameter 'log_mode' and set value to 'overwrite'

OR


-By editing config file from os level
edit global.ini
Change parameter 'log_mode' to 'overwrite'
Perform hdbnsutil -reconfig

Comments