Skip to main content

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
Labels:

Comments

Post a Comment

You might find these interesting

8 Must-Know Questions About Object Store on SAP Business Technology Platform

What is the problem that Object Store solves ? Modern enterprise systems increasingly deal with massive volumes of unstructured data such as documents, logs, media files, and backups. Traditional relational databases are not optimized for such workloads. What is Object Store ? Object storage—commonly referred to as blob storage—addresses this gap by providing scalable, durable, and cost-efficient storage for unstructured data. Object storage is a storage architecture designed to manage unstructured data as discrete units called objects.  Each object consists of: Binary data (file content) : Image , File etc Metadata (descriptive attributes) : File size, Content type, Last modified timestamp, Storage class (hot, cool, archive) Unique identifier (key or URL) : unique path-like string used to locate a blob inside a bucket Unlike file systems or relational databases, object storage does not rely on hierarchical file structures or schemas. The SAP BTP Object Store service is a managed, ...
Post a Comment
Read more