SAP HANA Articles - Page 25 of 63

M_SAVEPOINTS view stores Current and historical savepoint statistics. There is column DURATION which tells the total time taken by savepoint.You can extract the following information from the numbers in this view −CRITICAL_PHASE_DURATION shows the period of time during which the updaters were blocked in a savepoint. Normally, this should be in the milliseconds range, except for a global savepoint for data backup, which may take longer due to global synchronization across all nodes. If the critical phase duration is too long, there is probably some problem (e.g., I/O load is too high).DURATION shows the total time taken by a savepoint. ... Read More

M_SAVEPOINT_STATISTICS view shows information about executed savepoints.This view contains columns- START_TIME, STATE, VERSION and LAST_* relate to the last executed or currently-executing savepoint.Following information is available −

This can be checked using M_SAVEPOINT_STATISTICS. This view has a resettable counterpart. This means, you can also see the values since the last reset in the dependent view: M_SAVEPOINT_STATISTICS_RESET.To reset the values, use the SQL command −ALTER SYSTEM RESET MONITORING VIEW SYS.M_SAVEPOINT_STATISTICS_RESETor the management console command −monitor reset -n M_SAVEPOINT_STATISTICS_RESET

You can run savepoint manually by executing the below command −ALTER System SAVEPOINTChecking savepoint statistics of 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 More

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.

It does not allow base column tables, Attribute Views or Analytic views to add at data foundation. All Dimension tables must be changed to Dimension Calculation views to use in Star Join. All Fact tables can be added and can use default nodes in Calculation View.For more details, you can refer our tutorial link −https://www.tutorialspoint.com/sap_hana/sap_hana_calculation_view.htmYou have four tables, two Dim tables, and two Fact tables. You have to find list of all employees with their Joining date, Emp Name, empId, Salary and Bonus.This can be achieved using Calculation view with Star Join. You need to convert column based tables to ... Read More

Like other database, you can insert rows in column based table in SAP HANA using Insert statement. Insert statement can be written in SQL editor in HANA.To open SQL editor, you can select HANA system and click on SQL sign at top.Below SQL statements can be used to insert the data −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’);Read More

To change the language, go to Additional Properties tab in Database user logon and change the language as shown below −

To create an Attribute view, you have to navigate to Content tab → Package → New → Attribute ViewYou can select any of view type to implement a Text join in HANA.Add both the tables to Data Foundation and in Join type select Text join as shown below −Next is to save and activate Attribute view and text join is used.