SAP HANA Articles - Page 26 of 63

When you use a Text join in SAP HANA, following condition should be met −You should have Text table always on the right side in joinThere should be a Language columns definedBelow shows an example of Attribute join where Language column is used in text join −

To implement Text join, create a table −CREATE COLUMN TABLE TEST.P_INFO (PROD_ID BIGINT, P_CAT NVARCHAR(50)); INSERT INTO TEST.P_INFO VALUES (11, ’FURNITURE’); INSERT INTO TEST.P_INFO VALUES (14, ’ELECTRONICS’); INSERT INTO TEST.P_INFO VALUES (25, ’FURNITURE’); INSERT INTO TEST.P_INFO VALUES (76, ’ELECTRONICS’);2nd table −CREATE COLUMN TABLE TEST.PROD_DESC (PROD_ID BIGINT, LANGUAGE NVARCHAR(10), DESCR NVARCHAR(100)); INSERT INTO TEST.PROD_DESC VALUES (11, ’E’, ’Table’); INSERT INTO TEST.PROD_DESC VALUES (11, ’D’, ’Chair’); INSERT INTO TEST.PROD_DESC VALUES (14, ’E’, ’32 LED’); INSERT INTO TEST.PROD_DESC VALUES (14, ’D’, ’32 inch LCD’); INSERT INTO SAP_STUDENT.PRODUCT_DESC VALUES (25, ’E’, ’Comp Table’); INSERT INTO SAP_STUDENT.PRODUCT_DESC VALUES (25, ’E’, ’Mixer’);Note that it should have ... Read More

In SAP HANA, you can use Text join to fetch description based on user’s session language. When a text join is used, it finds out details in user’s preferred language.Text join can be applied on below modeling objects in SAP HANA −Attribute ViewAnalytic ViewCalculation View

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 −

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

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

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

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

Try the following SQL query −UNSET SYSTEM LICENSE ALL

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.