Found 694 Articles for SAP HANA

Exporting SAP HANA system measurement using hdbsql

SAP Developer
Updated on 24-Feb-2020 06:21:01

167 Views

To export this details you first need to have INIFILE ADMIN system privilege. Following hdbsql command can be used −SELECT ROUND(SUM(INSTANCE_TOTAL_MEMORY_USED_SIZE) / 1024 / 1024 / 1024, 0) AS DATABASE_MEMORY_USED_IN_GIGABYTES FROM M_HOST_RESOURCE_UTILIZATION RU, M_LANDSCAPE_HOST_CONFIGURATION HC WHERE RU.HOST = HC.HOST AND HC.INDEXSERVER_ACTUAL_ROLE IN ('MASTER','SLAVE');You can also run this command in SQL editor to get this details −

License expired and SAP HANA system is locked

SAP Developer
Updated on 24-Feb-2020 06:22:10

1K+ Views

You need to edit nameserver.ini file. Use the operating system user adm to edit the file /usr/sap//global/hdb/custom/config/nameserver.ini in the file system and add the following lines −[trace] licensing = debugOnce you edit the file → Restart the instance.Check the latest nameserver trace file nameserver_...trc, which is to be found under /usr/sap//HDB//trace/Check the end of that trace file to find the installation and system number in lines.Ex −Licensing    AbstractLicenseManager.cpp(00063) : Installation #  : "XXXX0XX234X"Licensing    AbstractLicenseManager.cpp(00063) : System #        : "XXXXXXXXXXXX4234523432434”You have to use this installation number and system number to request a new license key for ... Read More

Getting an error- license key couldn’t be installed in SAP HANA

SAP Developer
Updated on 24-Feb-2020 06:23:53

651 Views

A new permanent license key used to replace an expiring permanent license key must contain the same license identification data as are already installed. Only then it can be successfully installed. The license identification data consists of system ID, hardware key, installation number, and system number. Any difference in one of these four identifiers will result in the rejection of the license key. In most cases, this is the reason for the failure in license key installation.You can use Trace function to verify/identify the installation and system number of your database instance. If the current license key is still valid ... Read More

Checking monthly main memory utilization peak values in SAP HANA

SAP Developer
Updated on 24-Feb-2020 06:25:30

249 Views

This detail can be seen in system view- SYS.M_LICENSE_USAGE_HISTORY

System measurement of SAP HANA system in XML file

SAP Developer
Updated on 24-Feb-2020 06:27:04

503 Views

In a Single-Database system, proceed as follows to perform a system measurement of your SAP HANA system, which includes the system measurement of the SAP HANA database itself as well as of the relevant options and products −In the SAP HANA Studio, select your database in the navigator and choose Properties in the context menu of the system.Click on the "Export System Measurement" button. A File Browser dialog opens up allowing you to store the result of the system measurement, the measurement report, as an XML file to your local file system.Send this XML file to SAP as requestedThe XML ... Read More

SAP HANA view maintaining license details

SAP Developer
Updated on 24-Feb-2020 06:29:17

234 Views

Try executing the following SQL query −SELECT * FROM "SYS"."M_LICENSE";To get the hardware key, run the following SQL statement − SELECT HARDWARE_KEY, PRODUCT_NAME FROM M_LICENSE

Deleting all license key in SAP HANA

SAP Developer
Updated on 24-Feb-2020 06:29:49

378 Views

Try the following SQL query −UNSET SYSTEM LICENSE ALL

Getting License details, hardware key in SAP HANA

SAP Developer
Updated on 24-Feb-2020 06:34:06

611 Views

You can find this details in Properties pane of your HANA system. Select HANA system in Studio and right click → PropertiesWhen you navigate to License tab, you can find Hardware key.

Process to get SAP HANA license key from SAP Marketplace

SAP Developer
Updated on 17-Jun-2020 09:13:41

566 Views

To request a license key from SAP Marketplace, you require an S-ID and the “Request License Key” authorization for the installation number or customer number you require. To request your license key, you need to open SAP Service Marketplace −https://support.sap.com/en/my-support/keys.htmlNext is to launch license key application → It will prompt to enter SID and password again. Enter the credentials and you will reach to this page −To get license key from SAP Marketplace, you may need the following information −Provide the System IDProduct typeProduct VersionHostname of ServerSystem Usage TypeOperating System TypeTo proceed to the hardware data, choose “Continue”.Enter your hardware ... Read More

Validity of SAP HANA permanent license after expiry

SAP Developer
Updated on 24-Feb-2020 06:38:17

344 Views

Note that the validity of your permanent License key is till predefined date and when it is expired, a temporary license key is issued, with a validity for only 28 days. During this period, you have to install a permanent License key again.

Advertisements