Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 

Hello All,

Three weeks ago, SAP released HANA SPS09 with a lot of cool features and one of this features is SAP HANA Dynamic Tiering.

SAP HANA Dynamic Tiering enable us a possibility to implement a multi-temperature memory strategy in our DW and database.

In a data warehouse, data can be classified using the following categories based on access frequency: hot, warm, cold. In a data warehouse there are also different data usage profiles, which relate to the classification by access frequency. The multi temperature memory strategy of a company determines which memory areas are used to store data by access frequency and use

Concepts of Multi - Temperature Data :Multi-Temperature Data Management - Using the SAP HANA Database - SAP Library

Concepts of Extended Table:

The aim of this blog is to show the installation of the SAP Hana Dynamic Tiering for study purposes.

Before installing SAP HANA dynamic tiering we will understand the basic of system configuration.

At a minimum, an SAP HANA system with SAP HANA dynamic tiering requires one dedicated server for the SAP HANA host and one dedicated server for the SAP HANA dynamic tiering host. You cannot install SAP HANA and SAP HANA dynamic tiering on the same server. The SAP HANA and SAP HANA dynamic tiering systems share a common database containing regular and extended tables.

All hosts in the SAP HANA system, including the SAP HANA dynamic tiering host, require access to the HANA shared directory before installation begins.

In addition to the main host ( known as the worker), you can install a second SAP HANA dynamic tiering host (known as the standby) to provide failover functionality. You do not need a separate SAP HANA dynamic tiering license for the standby host, but it requires its own dedicated server.

See SAP HANA Architecture in the SAP HANA Master Guide for details on a SAP HANA system.

The installation is divided in 4 parts:

1 - Prepare HANA Master Machine;

2 - Prepare Dynamic Tiering Machine; Install SAP HANA Dynamic Tiering  - Part 2 - Prepare Dynamic Tiering Machine

3 - Install Sap Hana Dynamic Tiering; Install SAP HANA Dynamic Tiering  - Part 3 -  Installation

4 - Configuring Sap Hana Dynamic Tiering;

Prepare HANA Master Machine

For this installation, It was prepared:

  • Two Linux machine with SUSE 11.3, one machine for HANA master and one machine for Dynamic Tiering;
  • In HANA master machine, there is a directory /data1 and all installation packages in this directory;

Follow below the steps to prepare HANA Master Machine

Root Log On

#sudo su -

Install libstdc++6

#sudo zypper install libstdc++6

Install and configure a NFS Server

A shared file system is required to install SAP HANA Dynamic Tiering.

Designate one host as the file server. The file server hosts the shared file system.

Designate all other hosts needing to access the file system as file server clients. The clients access the shared file system on the file server.

There are many ways to set up a shared network file system (nfs).

Follow below one way to install and configure a NFS server:

#yast2 -i nfs-kernel-server

#chkconfig --add nfsserver

#/etc/init.d/nfsserver start

#vi /etc/exports

Include a line below in exports file

/data1/ 10.X.X.0/22(rw,no_root_squash,sync,no_subtree_check)

#exportfs -a

Creating Sapsys Group

#groupadd sapsys

#useradd -G sapsys sapadm

Install HostAgent

copy  sapcar and hostagent to  /data1/saphost

#cd /data1/saphost

#sapcar -xvf SAPHOSTAGENT

#./saphostexec -install

Install Sap Hana Dynamic Tiering - Part 2