SAP HANA Frequently Asked Questions | One Place for all

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 Savepoints SAP Note 2100040 – FAQ: SAP HANA CPU SAP Note 2101244 – FAQ: SAP HANA Multitenant Database Containers (MDC) SAP Note 2112604 – FAQ: SAP HANA Compression SAP Note 2114710 – FAQ: SAP HANA Threads and Thread Samples SAP Note 2115815 FAQ: SAP ……

Set Up SAP HANA System Replication with the SAP HANA

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.   There are 3 HANA nodes: A, B and C, named SiteA, SiteB and SiteC Site A : Primary Database Node Site B: Secondary Database Node / HA Node Site C: DR node Replication Mode: From Site A –> Site B : SYNC From Site B ……

Replication Modes between Sites : HANA Replication

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 an acknowledgement. Synchronous in-memory (SYNCMEM):The secondary system sends an acknowledgment back to the primary system as soon as the data is received in memory. The disk I/O speed on the secondary system doesn’t influence the primary’s performance. Site Distance  Replication Mode  < 100 KM SYNC ……

memorymanager –> Parameter : allocationlimit

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 system. Parameter: allocationlimit Description: Sets an upper limit of memory usable by individual processes in megabytes. When set to 0 or missing, the SAP HANA system implicitly calculates a default value based on global_allocation_limit. Multi-tenant database container (MDC) systems: In a tenant database, the parameter ……

inifile_checker –> Parameter : interval

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: SAP HANA Admin Guide and Frequently Used Configuration Parameters in SAP HANA

inifile_checker–> exclusion_[|*][/]

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 replication activated, any changes made on the primary are automatically replicated to the secondary sites; without this parameter replication activated changes should be manually duplicated on the other system.   Parameter: exclusion_[<inifilename>|*][/<LAYER>] Description: The ini file name can be replaced with an asterisk. The LAYER ……

[inifile_checker]/enable=true & [inifile_checker]/replicate = true

  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 be reflected in the secondary site . It helps to sync-up the parameters across all the HANA sites . If we don’t have [inifile_checker]/replicate = true : parameters set on HANA then there are chances that if we are changing any parameter in the primary site then ……

Hana table partitioning | re-partitioning | Improve Performance

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 takes lot of time and customer wants to optimize overall run-time of table partitioning . Here i am providing tips to improve total run-time of Hana table partitioning along with table partitioning steps: Run delta merge on table before re-partitioning . Command for delta merge “MERGE ……

How to Stop and Start SAP HANA Tenant Database

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 commands for Stop and Start SAP HANA Tenant Database.   How to Stop SAP HANA Tenant Database: ( SMH is TENANT DATABASE SID): alter system stop database SMH   How to verify if Tenant database has been stopped: Execute SQL command: select * from m_databases; ACTIVE ……

How to list all the HANA databases for Multi tenant Databases

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” then you’ll not get the list of all the tenant databases . M_DATABASES only shows the current SYSTEMDB. Solution : Provide DATABASE ADMIN or DATABASE STOP or DATABASE START privilege to the said user (in SYSTEMDB) then execute :  select * from M_DATABASES again from ……