SAP HANA studio is an Eclipse-based tool and provides a central development environment and an administration tool for HANA database. These are the features of HANA Studio client −HANA Studio is a client tool, which can be used to access local or remote HANA system. You can use HANA Studio for ... Read More

To fix this, you need to run T-Code: SMICM and this will open ICM Monitor Service Display. You need to maintain port number 80000 for HTTP in SMICM.

This can be found using following SQL command −SELECT * from USERS;

Consider the following example −Example            Id            Empl. NameEmpl.userEmpl.passwordJoining Date1 Employee 1  Emp1Emp1Pwd      9/11/20162 Employee 2Emp2Emp2Pwd16/08/20153Employee 3 Emp3Emp3Pwd  15/09/20164Employee 4Emp4  Emp4Pwd3/07/20145Employee 5  Emp5    Emp5Pwd 10/09/20126 Employee 6Emp6  Emp6Pwd  1/10/2013         Consider a scenario when a developer needs to analyze some data ... Read More

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

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 −

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

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/

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/

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.Read More