Skip to Content

What is Dynamic Tiering?:


The SAP HANA dynamic tiering option is a native big data solution for SAP HANA. The dynamic tiering option adds smart, disk-based extended storage to your SAP HANA database. Dynamic tiering enhances SAP HANA with large volume, warm data management capability.

The dynamic tiering option adds the extended storage service to your SAP HANA system. You use the extended storage service to create the extended storage store and extended tables. Extended tables behave like all other HANA tables, but their data resides in the disk-based extended storage store.

Your application automatically determines which tier to save data to: the SAP HANA in-memory store (the hot store), or extended storage (the warm store). When you use dynamic tiering to place hot data in SAP HANA in-memory tables, and warm data in extended tables, highest value data remains in memory, and cooler less-valuable data is saved to the extended store. This can reduce the size of your in-memory database.

[Credits: Dynamic_Tiering_Option_Master_Guide_en]

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]

  1. /hana/shared
  2. /hana/data/HDT
  3. /hana/log/HDT
  4. /hana/data_es/HDT
  5. /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

  1. Server (SAP HANA DB)
  2. 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.


The Data is retrieved from extended storage  🙂



Regards,

Muthu

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Pise Mangesh

    Great content and explaination.

    Question – Can a table be both in memory and extended and just the data is spread between the 2 table types?

    (0) 
    1. Remi ASTIER

      Hello Pise, what you are describing will happen in the future, one table could have hot partitions in memory and a warm partition in the extended storage server.

      Muthu, the minimum memory requirements to install the extended storage in a vm seems to be 8 GB.

      (0) 
  2. Santiago Jover Noguera

    Hi

    We’re in a Customer. We’ve installed Dynamic Data Tiering

    Service is running

    If we create a table as EXTENDED, we get this error message:

    create table “TEST”( “CODFIELD” VARCHAR (1) not null,

      “DESCFILELD” VARCHAR (50) null,

      primary key (“CODFIELD”)) USING EXTENDED STORAGE

    Error Message: “Could not execute ‘create table “TEST”( “CODFIELD” VARCHAR (1) not null, “DESCFILELD” VARCHAR (50) null, …’

    SAP DBTech JDBC: [471]: invalid data source name: __esstore$

    Any Idea??

    Thanks in advance

    (0) 
  3. Santiago Jover Noguera

    If we try to create an EXTENDED STORAGE:

    CREATE EXTENDED STORAGE AT ‘XXXX’ size 10 GB ENABLE DELTA

    We have this error message:

    Could not execute ‘CREATE EXTENDED STORAGE AT ‘XXXX’ size 10 GB ENABLE DELTA’ in 22 ms 832 µs .

    SAP DBTech JDBC: [403]: internal error: Extended Storage server already exists on host XXXX

    If we create and EXTENDED STORAGE without Host Name (optional), the system uses the first available dynamic tiering host where esserver is running in utility mode.

    CREATE EXTENDED STORAGE size 10 GB ENABLE DELTA

    We have this message:

    Could not execute ‘CREATE EXTENDED STORAGE size 10 GB ENABLE DELTA’ in 26 ms 850 µs .

    SAP DBTech JDBC: [403]: internal error: No esserver found running in utility mode on any host.

    If we try to delete this EXTENDED STORAGE

    DROP EXTENDED STORAGE

    We have this message:

    Could not execute ‘DROP EXTENDED STORAGE’

    SAP DBTech JDBC: [471]: invalid data source name: __esstore$

    Any idea??

    (0) 
  4. Sharad Pandey

    Hi– We have a query that once the SAP HANA Dynamic Tiering is configured on the HANA running SAP BW 7.4 , how does the BW objects are marked to be kept in the extended storage and what are those BW objects eligible to be stored in DT.

    Request to share some pointers and documents if any.


    Regards,

    Sharad

    (0) 

Leave a Reply