Found 1044 Articles for SAP

Difference between enforced and unenforced license in SAP HANA

SAP ABAP Expert
Updated on 17-Jun-2020 09:18:46

821 Views

In SAP HANA, following permanent license type is supported −Unenforced License: When you use an unenforced license key in SAP HANA and consumption of HANA system exceeds the license amount of memory, it doesn’t effect the operation of SAP HANA database.Enforced License: When an Enforced license key is installed and consumption of HANA system exceeds the license amount of memory, HANA system gets locked. If this situation occurs, HANA system has to be restarted or a new license key should be requested and installed.

Checking enforced license in SAP HANA

SAP ABAP Expert
Updated on 24-Feb-2020 07:01:59

927 Views

This details can be checked from M_LICENSE view in HANA database. Try executing below query in SQL editor −SELECT EXPIRATION_DATE, ENFORCED, PERMANENT, LOCKED_DOWN FROM "SYS"."M_LICENSE" ;When Enforced value column is shown false so it means that license in use is not Enforced and you are using unenforced license.

Use of parameter basepath_logvolumes_es in global configuration file in SAP HANA

SAP ABAP Expert
Updated on 24-Feb-2020 07:02:52

114 Views

basepath_logvolumes_es provides the default path to the dynamic tiering log directory (log_es). This path must be available to the dynamic tiering host, but need not be available to HANA hosts. Avoid including the default installation directory in the path.Value − File Path          Default − /HANA/log_es/

Use of parameter “basepath_datavolumes_es” in global configuration file in SAP HANA

SAP ABAP Expert
Updated on 24-Feb-2020 07:03:58

173 Views

basepath_datavolumes_es parameter provides the default path to the dynamic tiering data directory (data_es). This path must be available to the dynamic tiering host, but need not be available to HANA hosts. Avoid including the default installation directory in the path.Value − File PathDefault − /HANA/data_es/

Path for log based data backups in SAP HANA

SAP ABAP Expert
Updated on 24-Feb-2020 07:05:55

125 Views

All the information is available under global.ini file which stores global configuration properties for each service in the landscape.These are the global properties most frequently used for extended storage configuration −Name                                    Section                Value                  Defaultbasepath_logbackup      persistence                File path ($DIR_INSTANCE)/backup/log

Path for file based data backups in SAP HANA

SAP ABAP Expert
Updated on 17-Jun-2020 09:20:42

186 Views

All the information is available under global.ini file which stores global configuration properties for each service in the landscape.These are the global properties most frequently used for extended storage configuration −               Name                                                Section                                                  Value                  Defaultbasepath_databackup  persistence        File path($DIR_INSTANCE)/backup/data               

Time taken by savepoint to perform backup in SAP HANA

SAP ABAP Expert
Updated on 17-Jun-2020 09:21:16

335 Views

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

Checking information about executed savepoints in SAP HANA

SAP ABAP Expert
Updated on 24-Feb-2020 07:21:58

114 Views

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

SAP ABAP Expert
Updated on 24-Feb-2020 07:23:15

365 Views

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

Setting savepoint manually in SAP HANA system

SAP Developer
Updated on 24-Feb-2020 06:11:50

174 Views

You can run savepoint manually by executing the below command −ALTER System SAVEPOINTChecking savepoint statistics of SAP HANA

Advertisements