Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by SAP Developer
Page 5 of 7
Deleting all license key in SAP HANA
Try the following SQL query −UNSET SYSTEM LICENSE ALL
Read MoreSystem measurement of SAP HANA system in XML file
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 MoreChecking monthly main memory utilization peak values in SAP HANA
This detail can be seen in system view- SYS.M_LICENSE_USAGE_HISTORY
Read MoreLicense expired and SAP HANA system is locked
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 MoreExporting SAP HANA system measurement using hdbsql
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 −
Read MoreUsing Text join in SAP HANA
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
Read MoreExample of using Text join in SAP HANA
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 MoreUse of savepoints in SAP HANA
In SAP HANA database, changed data is automatically saved from memory to disk and at the interval on which it is saved is called savepoints and by default they are set to occur every five minutes. In SAP HANA, there is a persistence layer which is used to make these savepoint at regular interval. During this operation changed data is written to disk and redo logs are also saved to disk as well.The data belonging to a Savepoint tells consistent state of the data on disk and remains there until the next savepoint operation has completed. Redo log entries are ...
Read MoreSetting savepoint manually in SAP HANA system
You can run savepoint manually by executing the below command −ALTER System SAVEPOINTChecking savepoint statistics of SAP HANA
Read MoreUse of Persistence layer in SAP HANA
SAP Persistence layer is required in the following scenarios −In any database, main memory is volatile therefore data is lost during a restart or when a power outage occurs.Data needs to be stored in persisted medium.Backup & Restore is available.It ensures that the database is restored to the most recent committed state after a restart and that transaction are either completely executed or completely undone.
Read More