SAP HANA Lifecycle Manager !!!

SAP HANA Lifecycle Manager
SAP HLM by default will get installed together with HANA platform SPS06 installation and I’ll give a brief walkthrough on how to access, to start and to install HLM on HANA platform lower than rev60.

 

 

a) to access HLM:

• via browser: https://fqdn:1129/lmsl/HLM/SID/ui/?sid=SID
• via Hana Studio rev60 -> Lifecycle management
• via command -> /hana/shared/SID/HLM/hlmcli/hlmcli.sh --sid --sidadm_pwd - --help

 

Before you can access HLM, you need to ensure HLM is running on the server by ps -ef | grep -i HLM and you’ll get something return as below:


SIDadm   25882 25598  0 15:05 ?        00:00:00 /bin/bash /usr/sap/hlm_bootstraps/start-hlm.sh SID
SIDadm   25948 25882  0 15:05 ?        00:00:00 bash /usr/sap/SID/HDB10/../HLM/bootstrap-hlm.sh
SIDadm   25971 25948  0 15:05 ?        00:00:00 /bin/bash /usr/sap/hlm_bootstraps/SID/HLM/hlm.sh
SIDadm   26009 25971  0 15:05 ?        00:00:00 /bin/bash ./daemon.sh console -Dhlm.nonssl.port=51000 -Dhlm.installation.path=/hana/shared/SID/HLM -Dhlm.bootstrap.path=/usr/sap/hlm_bootstraps/SID/HLM -Dlogback.configurationFile=/usr/sap/hlm_bootstraps/SID/HLM/configuration/serviceability.xml -Dosgi.resolver.usesMode=ignore
SIDadm   26163 26009  0 15:05 ?        00:00:00 /bin/bash -c cd "/usr/sap/hlm_bootstraps/SID/HLM" ; "/usr/sap/hlm_bootstraps/SID/HLM/jvm/jre/bin/java" -server -XtraceFile=log/vm_@PID_trace.log -XX:ErrorFile=/usr/sap/hlm_bootstraps/SID/HLMserviceabilityerror.log -XX:HeapDumpPath=/usr/sap/hlm_bootstraps/SID/HLM/serviceability/heap_dump.hprof "-XX:+HeapDumpOnOutOfMemoryError" "-XX:+DisableExplicitGC" "-Xms512m" "-Xmx1024m" "-XX:PermSize=256M" "-XX:MaxPermSize=256M" "-Dosgi.requiredJavaVersion=1.6" "-DuseNaming=osgi" "-Dosgi.install.area=." "-Djava.io.tmpdir=./work/tmp" "-Djava.endorsed.dirs=lib/endorsed" "-Dorg.eclipse.equinox.simpleconfigurator.exclusiveInstallation=false" "-Dcom.sap.core.process=ljs_node" "-Declipse.ignoreApp=true" "-Dosgi.noShutdown=true" "-Dosgi.framework.activeThreadType=normal" "-Dosgi.embedded.cleanupOnSave=true" "-Dosgi.usesLimit=30" "-Dcatalina.config=file:config/catalina.properties" "-Dhttp.hostcontrol.connection" -classpath /usr/sap/hlm_bootstraps/SID/HLM/plugins/org.eclipse.equinox.launcher_1.3.0.v20120308-1358.jar:/usr/sap/hlm_bootstraps/SID/HLM/lib/org.eclipse.virgo.nano.authentication_3.6.0.RC1.jar:/usr/sap/hlm_bootstraps/SID/HLM/lib/org.eclipse.virgo.nano.shutdown_3.6.0.RC1.jar:/usr/sap/hlm_bootstraps/SID/HLM/lib/org.eclipse.virgo.util.env_3.6.0.RC1.jar -Dhlm.nonssl.port=51000 -Dhlm.installation.path=/hana/shared/SID/HLM -Dhlm.bootstrap.path=/usr/sap/hlm_bootstraps/SID/HLM -Dlogback.configurationFile=/usr/sap/hlm_bootstraps/SID/HLM/configuration/serviceability.xml -Dosgi.resolver.usesMode=ignore org.eclipse.equinox.launcher.Main -console 2>>"/usr/sap/hlm_bootstraps/SID/HLM/hlm_daemon.log"
SIDadm   26164 26163  6 15:05 ?        00:01:11 /usr/sap/hlm_bootstraps/SID/HLM/jvm/jre/bin/java -classpath /usr/sap/hlm_bootstraps/SID/HLM/plugins/org.eclipse.equinox.launcher_1.3.0.v20120308-1358.jar:/usr/sap/hlm_bootstraps/SID/HLM/lib/org.eclipse.virgo.nano.authentication_3.6.0.RC1.jar:/usr/sap/hlm_bootstraps/SID/HLM/lib/org.eclipse.virgo.nano.shutdown_3.6.0.RC1.jar:/usr/sap/hlm_bootstraps/SID/HLM/lib/org.eclipse.virgo.util.env_3.6.0.RC1.jar -server -XtraceFile=log/vm_@PID_trace.log -XX:ErrorFile=/usr/sap/hlm_bootstraps/SID/HLMserviceabilityerror.log -XX:HeapDumpPath=/usr/sap/hlm_bootstraps/SID/HLM/serviceability/heap_dump.hprof -XX:+HeapDumpOnOutOfMemoryError -XX:+DisableExplicitGC -Xms512m -Xmx1024m -XX:PermSize=256M -XX:MaxPermSize=256M -Dosgi.requiredJavaVersion=1.6 -DuseNaming=osgi -Dosgi.install.area=. -Djava.io.tmpdir=./work/tmp -Djava.endorsed.dirs=lib/endorsed -Dorg.eclipse.equinox.simpleconfigurator.exclusiveInstallation=false -Dcom.sap.core.process=ljs_node -Declipse.ignoreApp=true -Dosgi.noShutdown=true -Dosgi.framework.activeThreadType=normal -Dosgi.embedded.cleanupOnSave=true -Dosgi.usesLimit=30 -Dcatalina.config=file:config/catalina.properties -Dhttp.hostcontrol.connection -Dhlm.nonssl.port=51000 -Dhlm.installation.path=/hana/shared/SID/HLM -Dhlm.bootstrap.path=/usr/sap/hlm_bootstraps/SID/HLM -Dlogback.configurationFile=/usr/sap/hlm_bootstraps/SID/HLM/configuration/serviceability.xml -Dosgi.resolver.usesMode=ignore org.eclipse.equinox.launcher.Main -console

 

b) If nothing returns, start HLM:


/hana/shared//HLM/bootstrap-hlm.sh


If folder /HLM don’t exist on the server, means HLM is not installed on the server.


c) to install HLM:


via HANA studio rev60 by using SUM4HANA.
I’ll skip this method where the steps are just similar when performing HANA DB revision update using SUM4HANA.

 

Manual Installation:
i) download SAPHANALM06_0-10012745.SAR or latest from SMP
ii) extract it to temp directory, eg: HLM_install
iii) copy SAPHANALM06_0-10012745.SAR to the temp directory where you extracted the SAR earlier, eg: HLM_install as the SAR is needed during installation.
iv) Ensure SAPHOSTAGENT is above level 149, advisable to update it to the latest level. Level 153 till today.
v) go to the extracted temp directory and run ./hdbinst
Just click enter when prompt if you are running single Hana Database.


SAP HANA Lifecycle Manager Installation kit detected.
SAP HANA Database Installation Manager - SAP HANA HLM Installation 1.50.00.000000
*********************************************************************************
Options:
  SAP HANA system ID | Description
---------------------------------------------------------
  SID                | SAP HANA Database SID 1.00.57.378530
Enter SAP HANA system ID [SID]:
Root user password (SSH connectivity):
Root user SSH key passphrase (SSH connectivity):

 

 

The installation will complete in jiffy and now, enjoy using HLM!

Setup and Configure a SAP Hana Dynamic Tiering...!!!

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
Done

 

  

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

 

Now check hana studio

 

 
Monitoring of DT in HANA cockpit

 

The monitoring of DT is done over the cockpit, its straight forward

 

The configuration is completed.