SAP HANA Dynamic Tiering Installation Document
SAP HANA Dynamic Tiering is a tool used to move data between in-memory (“hot”) and disk storage (“warm”) in a HANA landscape. Information that needs to be queried frequently is kept as hot data, while information that is rarely accessed is stored in extended tables as warm data. This decreases the cost and memory footprint of the SAP HANA cloud without sacrificing performance.
Dynamic Tiering Landscape Setup:
Dynamic Tiering feature [SAP HANA Extended Storage feature] is supported in since HANA SP09.
This blog is about My Experience on Dynamic Tiering Setup. This blog will helpful for you to make the Dynamic Tiering setup in your landscape.
I have two Linux Hosts [I named as LinuxHost1, LinuxHost2] with same configuration and same root user and password.
HANA Server will be installed on LinuxHost1 and ES Server will be installed on LinuxHost2.
Both the components cannot be installed on same Linux machine.
Shared File systems:
The following file systems in the two Linux hosts should have shared persistence.
[I am going to Install HANA System with SID: HDT]
- /hana/shared
- /hana/data/HDT
- /hana/log/HDT
- /hana/data_es/HDT
- /hana/log_es/HDT
Installation Parameters:
I install HANS System using batch file. [Batch file is stored in LinuxHost1] [File Format *.cfg]
The following Parameters, especially we have to mention for Dynamic Tiering Setup.
1. addhosts:
We have to mention the details of LinuxHost2 and its role.
2. Component_dirs:
In Component_dirs parameter,
we have to mention location of HANA DB server Installation File package and HANA Option (Dynamic Tiering) Installation File package.
The format is Component_dirs = <HANA_Installation_Path>, <HANA_Option_Installation_path> comma separates both the installation packages.
I tell how to find out the location of installation package:
We have to choose the folder path where we have manifest file:
<Component_dirs>: Location of <HANA_Installation_Package>:
<Component_dirs>: Location of <HANA_Option_DynamicTiering_Path>
So these two folder paths have been mentioned in <component_dirs> parameter
3. Other Required Parameters:
Then we have to mention all other required parameters in the batch file (cfg file) like SID, Instance Number, DB_Mode (Single Container), sapadm password, system administrator (<SID>adm) password, system_user_password, user_id, group_id, sapmnt path, data path and log path.
Installation Process:
Once Configuration file is ready, we have to start Installation using hdblcm with configuration file.
During Installation Process, To be Installed Components will be listed.
Components are
- Server (SAP HANA DB)
- ES (Dynamic Tiering).
Select the option all, which will install HANA Server in LinuxHost1 and Dynamic Tiering setup [ES Server] in LinuxHost2.
Installation Process will be started.
LinuxHost2 will become additional host and will act as Extended Storage Server.
Once Installation Process Completed, HANA Server is installed in LinuxHost1 and Dynamic Tiering setup [ES Server] is installed in LinuxHost2.
List of Process:
Once Installation Completed Successfully, I am going to check the running process in two Hosts.
Linux Host1: (HANA DB)
Name server, preprocessor, compile server, index server, statistics server, xs engine are running in Linux server1.
Linux server2: (ES)
Name server and ES server are running in Linux server 2.
Studio:
I am Connecting HDT System from the Studio. It will display list of servers from Both the Hosts.
How to Make Dynamic Tiering is running:
After Installation completed, If we check the system, We can see the Information that Dynamic Tiering is Installed But not running.
Execute the query,
SELECT * from M_SERVICES
Co-ordinater Type for esserver is NONE.
So Dynamic Tiering is Installed But not running. How can we make Dynamic Tiering is running?
Create Extended Storage in LinuxHost2:
To make Dynamic Tiering is running, we have to create Extended Storage in LinuxHost2.
Execute the following SQL Query in HDT System.
CREATE EXTENDED STORAGE AT ‘<full_host_name_of_Linuxhost2>’size 10 GB ENABLE DELTA
Now check M_Services:
Now Co-coordinator Type for esserver is MASTER and Dynamic Tiering is running
Extended Storage Table Creation:
We have to use <EXTENED STORAGE> Clause in SQL Query to create Extended Storage Table.
SQL Query:
CREATE TABLE “SHANMUGAVEL”.t2(A INT, B INT NULL, C INT NOT NULL) USING EXTENDED STORAGE;
Extended Storage Table T2 is created.
Insert:
Now I am inserting the data to Extended Storage Table and It will be stored in Extended storage
Insert into “SHANMUGAVEL”.”T2″ values (1, 1, 1)
Select:
I am checking Data Preview from Extended Storage Table.
SAP HANA Dynamic Tiering Installation Document
