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
Post a Comment