License Key Types in SAP HANA

SAP HANA License and keys are required to use SAP HANA database. You can install or delete HANA License keys using SAP HANA studio and Like all SAP products,we need an valid license to run SAP HANA for production systems.

Types of License keys in SAP HANA :

SAP HANA system supports two types of License keys :

1> Temporary

2> Permanent -  Enforced and Unenforced

Temporary License Key − A temporary license keys is installed by default when you install the HANA database. These keys are valid only for 90 days and and upon expiration the HANA system is locked down so you should request permanent license keys from SAP market place before expiry .

Permanent License Key − SAP provides this license upon customer request ,known as permanent license. Permanent License keys are valid only till the predefine expiration date .Once expiration date period is over the license will get expired and a temporary license will be installed automatically for 28 grace period and During this period, you have to install a permanent License key again.

Permanent license keys are of two types for HANA system :

Unenforced − If unenforced license key is installed Then system will issue a warning message upon over usages of SAP HANA licensed memory amount but it will not get locked down, operation of SAP HANA is not affected in this case.

Enforced − this HANA license are based on the memory usage and 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.

Example : you can install a 1 TB memory HANA system but can only license it for 256 GB usage.If the system usage is increased over licensed amount then the system will locked down .

License Expire in SAP HANA

SAP HANA License Management

How to check if the installed HANA license is enforced or unenforced ?

Execute following query and if the "Enforced" column value is "False" then your license is not enforced.

SELECT EXPIRATION_DATE,ENFORCED,PERMANENT,LOCKED_DOWN FROM "SYS"."M_LICENSE";

SAP HANA License Management

This topic describes how to request SAP HANA database License from service market place and apply the same to the database. This also describes how to check the SAP HANA License properties on a database using SAP HANA Studio and using DB commands.

To check the SAP HANA License Properties by using SAP HANA Studio :

Steps: 
1> Connect to the required system via HANA Studio
2>  In SAP HANA Studio Navigator, connect to an instance of the SAP HANA Database Engine using relevant user (SYSTEM).
3> Right-click to the desired Instance and select properties.
4>  Select License, the information about license appears.
5>  A dialog box appears reflecting the status of the action.

Right Click on HANA system → Properties → License

Note : Above information can also be retrieved by executing following query.

SELECT * FROM "SYS"."M_LICENSE";

FAQ : How to de-installed License keys in SAP HANA ?

License keys can be de-installed using the following SQL statement:

UNSET SYSTEM LICENSE ALL

This command will delete all existing license keys installed so far in the database instance. Furthermore, it sets the system immediately to lockdown state. A new valid permanent license key needs to be installed in order to unlock the instance. Like installing a license key, your user needs the LICENSE ADMIN system privilege to delete the license keys.

Link for : License Expire in SAP HANA

Link for : License Key Types in SAP HANA

License Expire in SAP HANA

To run SAP HANA database and function properly, you must need to obtain a valid license. Once you have installed a valid permanent license, your system is functional until this license expires. If the current permanent license expires, a temporary license will be automatically in-stalled. This temporary license following a permanent license is only valid for 28 days.

All relevant information on the currently valid license key is available in the system view M_LICENSE. It is also shown in the studio in the license properties section shown above.

License keys can be installed using the SQL statement .Please follow below steps for setting up license key.

Step 1:

---Login in to DB from Terminal Using Backup User:

vsa00xyz:HDB:SIDADM>  hdbsql -jU bkpkey

Welcome to the SAP HANA Database interactive terminal.

Type:  \h for help with commands
       \q to quit

hdbsql=>

Step 2:

hdbsql=>
hdbsql SID=> SELECT * FROM M_LICENSE
HARDWARE_KEY,SYSTEM_ID,INSTALL_NO,SYSTEM_NO,PRODUCT_NAME,PRODUCT_LIMIT,PRODUCT_USAGE,START_DATE,EXPIRATION_DATE,LAST_SUCCESSFUL_CHECK,PERMANENT,VALID,ENFORCED,LOCKED_DOWN,MEASUREMENT_XML
"N3038679033","ABC","SAP-INTERN","000000000312563985","SAP-HANA",64,37,"2015-09-20 00:00:00.000000000","2016-09-21 23:59:59.999999000","2015-09-21 00:00:00.000000000","TRUE","TRUE","FALSE","FALSE","GXML1.0SAPHANA1.0BKPKEY
"
1 row selected (overall time 58.185 msec; server time 56.341 msec)

hdbsql ABC=>


Step 3:

Copy the hardware key then generate license using SAP Portal & then use below command:

hdbsql SID=>set system license 'pass here license key'

Example:

hdbsql SID=>set system license 'MIIBOwYJKoZIhvcNAQcCoIIBLDCCASgCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQE''

License Related SQL :

SELECT * FROM M_LICENSE

SELECT HARDWARE_KEY, PRODUCT_NAME FROM M_LICENSE

select DB_HOST, ALERTID, ALERTMESSAGE, ALERTLEVEL from DBSERVERALERT where alertmessage like '%license%' ORDER BY DB_HOST  ---checking license status

License Key Types in SAP HANA

SAP HANA License Management