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