How to check SAP HANA Hardware Key when Db is down

Requirement: We want to know the HARDWARE Key of our HANA system. Hardware key is mandatory to request license key from SAP Marketplace.

Prerequisite:

  • Database User: We need an HANA DB user with LICENSE ADMIN or CATALOG READ or DATA ADMIN assigned.
  • SID<ADM> credentials: To log into SAP HANA OS level we need sid<adm> credentials.

Steps:

Logon to HANA host with <SID>adm user.
Once we are logged in as <SID>adm, we can directly execute the hdbsql command ,or we can go to following path and execute the hdbsql command.

         cd /hana/shared/<SID>/hdbclient
 

HDBSQL Command :

hdbsql  -n localhost -i 00 -u HANADbUser -p yourUserPassword

Please note: In our case the system number is 00 , update the instance number accordingly.
Now execute following SQL command to get the HARDWARE key.
SQL Command: “SELECT * from M_LICENSE” ;
Output :
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
X0891103253“,”HDB”,”unknown”,”unknown”,”SAP-HANA”,0,22,?,?,?,”FALSE”,”FALSE”,”FALSE”,”TRUE”,””
Highlighted in green is the Hardware key.
When DB is down,You can check fro HANA studio->Properties

Leave a Reply