Requirement: We want to know the HARDWARE Key of our HANA system.
Hardware key is mandatory to request license key from SAP Marketplace.
Prerequisite:
Steps:
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.
HDBSQL Command :
cd /hana/shared/<SID>/hdbclient
hdbsql -n localhost -i 00 -u
HANADbUser -p yourUserPassword
Please note: In our case the system number is 00 , update the instance number accordingly.
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.
Related: