How to enable log overwrite mode in SAP HANA Using SQL statement

If you don't want to be spend time on LOG maintenance :

Follow below steps:

#  su - hdbadm

$ hanadb1 : /usr/sap/HDB/HDB00> hdbsql

hdbsql ==> connect -n <server name> -i  <instance number> -u <user> -p <password>

hdbsql==> ALTER SYSTEM ALTER CONFIGURATION ('global.ini','SYSTEM')SET ('persistence'.'log_mode') = 'normal' WITH RECONFIGURE

OR

hdbsql==> ALTER SYSTEM ALTER CONFIGURATION('global.ini'.'SYSTEM')SET ('persistence'.'log_mode') = 'overwrite' WITH RECONFIGURE