SAP HANA FAQ – Most Frequently Asked Questions for SAP HANA provides a quick reference: SAP Note 2057595 – FAQ: SAP HANA High Availability SAP Note 2073112 – FAQ: SAP HANA Studio SAP Note 2081591 – FAQ: SAP HANA Table Distribution SAP Note 2082286 – FAQ: SAP HANA Graph SAP Note 2100009 – FAQ: SAP…
HANA System Replication is one of the important topic in SAP HANA. Being used in the context of high availability and disaster recovery scenario, It is really important to learn how to setup HANA System Replication in multi-tier replication scenario. In this scenario we are enabling HANA System Replication – In Multi-tier scenario. …
Here i am explaining different replication Modes between Sites in the HANA Replication setup. Synchronous (SYNC) : The secondary system sends an acknowledgment back to the primary system as soon as the data is received and persisted to the log volumes on disk. Asynchronous (ASYNC): Asynchronous replication, the primary does not wait until the secondary sends…
Parameter : allocationlimit Key Highlights : This parameter is very useful in the Multi-tenant database container (MDC) system to set memory limit on each tenant system. Example : If we have 4 tenant systems in the landscape then we can set on indexsever.ini file –> allocationlimit for each tenant system to the accepted memory limit for each tenant…
Parameter: interval Description: Sets a time interval in seconds between two checks for differences of ini file parameters between primary and secondary systems in a system replication scenario. To disable/enable those checks, set the parameter [inifile_checker] enable. Value: Positive integer Default: 3600 (seconds = 1 hour) Restart required: No Ref:…
Key Highlights: This parameter will help in the scenario where we don’t want to replicate few parameter from primary to secondary site. Scenario where we want to have different value of particular parameters in primary and secondary site. This parameter is helpful where replication on the primary site with [inifile_checker]/replicate = true is enables With parameter…
inifile_checker –> enable = True & [inifile_checker]/replicate = true Key Highlights : [inifile_checker]/replicate = true- This parameter is very useful in the scenario where we have muli -tier and multi-target replication setup in the landscape . If we are changing any parameter in the primary site and [inifile_checker]/replicate = true- parameter is enabled then automatically it will…
Hana table partitioning is one of major problems for most of the customers to re partition of HANA tables due to the reason that a table partition cannot contain more than 2,147,483,648 (2 billion) rows. During the time customer need to perform table re partitioning due to 2 billion limit and For large tables – table partitioning…
There are multiple way to stop and start SAP HANA Tenant Database . But i personally prefer to stop and start SAP HANA Tenant Database using SAP HANA Studio . Step 1- Launch SAP HANA Studio and open SQL console . Once SQL Console is open then you can execute below mentioned sql…
In this tutorial I’ll explain How to list all the HANA databases for Multi tenant Databases. Step 1– Launch SAP HANA Studio and open SQL console .( using SYSTEMDB) Step 2 – Execute query ” select * from m_databases “. Note: If above query is executed from different user apart from “SYSTEM”…