Temporary License keys are automatically installed when you install the HANA database. These keys are valid only for 90 days and you should request permanent license keys from SAP marketplace before the expiry of 90 days period after installation.

Permanent License Key

Permanent License keys are valid only till the predefined expiration date. License keys specify the amount of memory licensed to target HANA installation. They can be installed from SAP Marketplace under Keys and Requests tab. When a permanent License key expires, a temporary license key is issued, which is valid for only 28 days. During this period, you have to install a permanent License key again.

There are two types of permanent License keys for HANA system −

Unenforced − If unenforced license key is installed and consumption of HANA system exceeds the license amount of memory, the operation of SAP HANA is not affected in this case.
Enforced − If Enforced license key is installed and consumption of HANA system exceeds the license amount of memory, HANA system gets locked. If this situation occurs, HANA system has to be restarted or a new license key should be requested and installed.

There are different License scenarios that can be used in HANA system depending on the landscape of the system (Standalone, HANA Cloud, BW on HANA, etc.) and not all of these models are based on the memory of HANA system installation.

SAP HANA System Lockdown

There are various scenarios when your SAP HANA system locks down. This happens when a License key expires or license keys are deleted.

When a system is locked, it is not possible to run any transactions by connecting to the database. To renew license keys/unlock the system, only HANA user with License Admin system privilege can connect to HANA database.

Following are the scenarios which can cause the lockdown of SAP HANA system −

When hardware license key changes and Temporary license key is used in SAP HANA system.
Temporary License key expires in HANA system.
All license keys installed in HANA database are deleted.
SAP HANA system permanent license key expires and has not been renewed in the grace time period of 28 days.
You are using Enforced License key and your memory consumption exceeds the licensed amount and tolerance limit assigned.

Note − It is not possible to take a backup of HANA system when the system is locked down.

How to Check and Install License Keys of HANA?

The role required to install/delete an existing License Key: LICENSE ADMIN

To check and install a new License key, navigate and right-click HANA system → Properties → License.

SAP 26

It tells about License type, Start Date and Expiration Date, Memory Allocation and the information (Hardware Key, System Id) that is required to request a new license through SAP Marketplace.

Now to renew/install a new License key, navigate to Install License key → Browse → Enter Path, is used to install a new License key. The Delete option is used to delete any old expiration key.

All Licenses tab under License tells about the Product name, description, Hardware key, First installation time, etc.

To delete the license key, you can use SAP HANA Studio or it can also be performed using SQL console. Deleting a license key is required in various scenarios such as you have installed permanent license keys with an incorrect installation number or incorrect system number on the database.

To delete a license key, right-click HANA system → Properties → License → Delete License Key.

SAP 27

You can also execute the following SQL command to delete all license keys in HANA database that results in a system lockdown.

UNSET SYSTEM LICENSE ALL

Multitenant DB Container Management

SAP HANA system can be configured in a single container database system or multiple container system. To set up tenant databases, your system should be configured in multiple container mode. You can also convert a single container mode to multiple container mode, before you create and configure tenant database.

When SAP HANA system is installed in multiple container mode, only the system database is created initially. Tenant databases are created by the administrator and then later it can be configured.

You can convert a SAP HANA system to support multitenant database containers using the SAP HANA Database Lifecycle Manager (HDBLCM) resident program in the graphical user interface.

When you convert a Single container system to multitenant database container using HDBLCM, it can’t be reversed.

You can open SAP HANA database lifecycle Manager using the following URL in a web browser.

https://hostname:1129/lmsl/HDBLCM/HDB/index.html

You can also open this browser from SAP HANA Studio. Right-click HANA system → Lifecycle Management → Platform Lifecycle Management → SAP HANA Platform Lifecycle Management.

SAP 28

You can also perform conversion of single container to multitenant database system using SAP HANA Cockpit. Navigate to SAP HANA Platform Lifecycle Manager.

Click Convert to Multitenant Database Containers as shown in the following screenshot.

SAP 29

Creating a Tenant Database

You can create a tenant database in SAP HANA multiple container system using SAP HANA cockpit. A tenant database can be created from the system database as and when it is required. A tenant database contains all the data – including users, configuration, and connection properties of the original system.

Step 1 − To create a tenant database, you need to navigate to Manage Database app of SAP HANA Cockpit.

SAP 30

Step 2 − To access this tile in SAP HANA Cockpit, you must have the following role assigned: sap.hana.admin.cockpit.sysdb.roles::SysDBAdmin

Step 3 − In the footer toolbar, you have to navigate to Overflow menu → Create Tenant Database.

SAP 31

Step 4 − Enter the name of tenant database and the system user password. You can also specify OS user and group of tenant database.

You can select various optional fields while creating tenant database, such as creating OS user or to add tenant database to a group and many more.

Step 5 − Once you complete the wizard, click Create Tenant Database and it may take some time to complete the creation process.

New database that has been created has been added to manage database app in SAP HANA cockpit. You can also check newly created tenant database using database view command −

SELECT * FROM “PUBLIC”.”M_DATABASES

A HANA database administrator can start or stop the tenant databases either individually or all in one go, by starting/stopping the whole system. A tenant database which is individually stopped can’t be started with the whole system and you need to start it individually.

Select the tenant database that you want to start and stop under manage database app in HANA Cockpit. Click Start Tenant database/Stop tenant database to perform a start and stop.

So, this brings us to the end of blog. This Tecklearn ‘SAP HANA License Management and Multitenant DB Container Management’ blog helps you with commonly asked questions if you are looking out for a job in SAP Hana Administration and SAP Domain. If you wish to learn SAP Hana Administration and build a career in SAP domain, then check out our interactive, SAP HANA Administration Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/sap-hana-administraion/

SAP HANA Administration Training

About the Course

SAP HANA Administration training will help you learn SAP HANA administration tools, security and user management, system management and availability, data provisioning and integration with non-SAP systems and more. You will deploy SAP HANA Studio, automate through OS scripts, command line admin tools through hands-on projects and case studies. This course is designed to clear the HA200 SAP HANA Operations and Administration Certification conducted by SAP and helps you get the best jobs in top MNCs.

Why Should you take SAP HANA Administration Training?

The average salary for SAP HANA Database Administrator ranges from approximately $65,843 yearly for Administrator to $143,051 yearly for Enterprise Architect. – Indeed.com
SAP HANA is one of the top tools for working with real-time data due to the transformational nature of this tool. The role of an SAP HANA Administration and Operations personnel is critical of the success of SAP HANA deployment in any industrial set-up.
Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.

What you will Learn in this Course?

Overview of SAP HANA

Overview of SAP HANA
Features and Benefits of SAP HANA
SAP HANA Components
Concept of SAP HANA guides
Scenarios in SAP HANA Administration

Architecture of SAP HANA

What is SAP HANA persistence?
Concept of Sizing in SAP HANA
Process of achieving scale out in SAP HANA
How SAP HANA achieves in-memory computation
Concept of columnar database
How SAP HANA is so fast with comparison to other tools

SAP HANA installation

Overview of SAP HANA tools

SAPA HANA Studio for Administration activities in SAP HANA
Accessing local and remote HANA systems using Client Tool
Monitor, Control, Configure and Administer the SAP HANA database using DBA Cockpit
Using HANA Studio Information modelling and data provisioning in HANA database
SAP HANA Transport

SAP HANA Operations

Privileges in HANA
Configure Password Policy and create user in SAP HANA
Auditing in SAP HANA

SAP HANA Smart Data Access

Data Provisioning in SAP HANA

Leveraging SAP HANA technology and integration architecture for enriching, cleansing and transforming data from disparate sources
Data replication with the SAP Landscape Transformation (SLT)
Implementing SLT Configuration with SUSPEND LOAD

SAP HANA Operations

Create Repository and Job Server
SAP GRC Architecture

Administration Operations in HANA Studio

Updating HANA database using lifecycle management
Security in SAP HANA
Sessions and Transactions in SAP HANA
Configure System Replication using HANA Cockpit

Migration to SAP HANA using DMO

Performance Monitoring and Analysis in SAP HANA

Got a question for us? Please mention it in the comments section and we will get back to you.

505