SAP Hana Dynamic Tiering Setup and Configuration
In my documentation I’ll explain how to setup and configure a SAP Hana Dynamic Tiering scenario in my test environment. I will show in detail step and configuration point to achieve this configuration.
For my HDT test case I’ll use my own lab on Vmware Vsphere 5.1.0 and run Hana revision 91, I’ll reuse my existing environment setup in my previous documentation.
Disclaimer: this is a personal documentation for test purpose; I will take in consideration the sizing for DT.
In order execution
- Download Hana DT media
- Prepare DT specific filesystem
- Install DT component
- Add new host for DT worker
- Configure DT storage
- Monitoring of DT in hana cockpit
Guide used
SAP Hana Dynamic Tiering Administration Guide SP9
SAP Hana Dynamic Tiering Operation
Note used
2140959 – SAP HANA dynamic tiering – additional information
2086829 – SAP HANA DT: Sizing of Dynamic Tiering component of SAP HANA
Link used
http://help.sap.com/hana_platform
Overview Architecture
In my previous documentation “SAP Hana TDI setup – VMware 5.1” I have explain and setup different scenario of Hana deployment, I’ll reuse my master hana system “hana01” and create a new host from template to add it as “Hana DT worker” host.
Download Hana DT media
In order to install Hana DT specific media needs to be download, those media can be download unde :
“Install & Upgrade -> Hana Platform Edition -> SAP Hana Dynamic Tiering”
Once downloaded, I unzip the file and place the media in my repository
Prepare DT specific filesystem
Before to start with the setup of Hana DT, specifics filesystem needs to be mounted on the hosts
Make sure the folder SID exist under “/hana/data_es/” before to run the installer.
Install DT component
Now that the media and the filesystem are ready it’s time to deploy the DT component on the master node.
The deployment can be performed in 3 different ways:
Using the command line tool “hdblcm” by choosing option 9 under “/hana/shared/HB1/hdblcm”
Using the graphical tool “hdblcmgui” under under “/hana/shared/HB1/hdblcm”
And finally by the web over “Hana Lifecycle Management”
For my document I’ll use the web option
I specify my DT component folder with sub folder
Installation done
Add new host for DT worker
Now completed we need to install the additional host which will be used as “Hana DT worker”, to do this we can use “hdblcm” or “hdblcmgui” option.
I’ll go by the hdblcmgui option:
I want to use all my NIC so I keep the Global option
Review and launch
Configure DT storage
The new worker host deployed we can check on hana studio to validate
On the overview dashboard we can see now that DT has been installed but still need to be configured
Do perform it we need to do it over the Hana cockpit, but before the dynamic role needs to be assign
Once assigned, add the necessary dashboard in the cockpit
I define my storage size for my Extended Table and hit create
Done
Note: the configuration can be change to extend disk size to meet requirements
Monitoring of DT in HANA cockpit
The monitoring of DT is done over the cockpit, its straight forward
The configuration is completed.
Williams
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
Hello Sharad,
If you want to move to move data to warm storage, convert appropriate column tables into extended store tables from the studio by right-click on the table that you want to move in ES.
Williams
Thank you for posting this document.
Regards,
Shiva