Checking information about executed savepoints in SAP HANA

Published on 05-Feb-2018 18:11:19
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 −

Checking savepoint statistics of SAP HANA

Published on 05-Feb-2018 18:11:59
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_RESETRead More

Setting savepoint manually in SAP HANA system

SAP Developer
Published on 05-Feb-2018 15:44:33
You can run savepoint manually by executing the below command −ALTER System SAVEPOINTChecking savepoint statistics of SAP HANA

Types of Array in Java

Published on 05-Feb-2018 09:47:09
Java supports single dimensional and multidimensional arrays. See the example below:Example Live Demopublic class Tester {    public static void main(String[] args) {       double[] myList = {1.9, 2.9, 3.4, 3.5};       // Print all the array elements       for (double element: myList) {   ... Read More

Use of savepoints in SAP HANA

SAP Developer
Published on 05-Feb-2018 15:46:16
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 ... Read More

Use of Persistence layer in SAP HANA

SAP Developer
Published on 05-Feb-2018 15:43:18
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 ... Read More

Advantages and disadvantages of arrays in Java

Published on 05-Feb-2018 09:25:24
BenefitsEasier access to any element using the index.Easy to manipulate and store large data.DisadvantagesFixed size. Can not be increased or decrease once declared.Can store a single type of primitives only.

Persistence layer in SAP HANA

SAP Developer
Published on 05-Feb-2018 15:42:35
In SAP HANA, Persistence layer is used for handling all operational and transaction data to take secure backup and restoring data incase of corruption or database crash. It provides use of Save point which can be used for restoring data.With use of concept of persistence layer of SAP’s relational database, ... Read More

Real time data replication in SAP HANA

SAP Developer
Published on 05-Feb-2018 15:42:04
SAP HANA Replication allows migration of data from source systems to SAP HANA database. Simple way to move data from existing SAP system to HANA is by using various data replication techniques.System replication can be set up on the console via command line or by using HANA studio. The primary ... Read More

Arrays in Java

Published on 05-Feb-2018 09:29:10
You can create an array by using the new operator with the following syntax −SyntaxarrayRefVar = new dataType[arraySize];The above statement does two things −It creates an array using new dataType[arraySize].It assigns the reference to the newly created array to the variable arrayRefVar.Declaring an array variable, creating an array, and assigning ... Read More