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: http://help.sap.com/saphelp_nw74/helpdata/en/c0/fbf3f7bef240bfb3e93d3d5e005619/frameset.htm
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 –
#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
Include a line below in exports file
Creating Sapsys Group
#useradd -G sapsys sapadm
copy sapcar and hostagent to /data1/saphost
#sapcar -xvf SAPHOSTAGENT