Tag Archives: HANA Database

How to Check HANA Replication status

How to Check HANA Replication status? There are some ways to gather information about the overall status of the sites and of the system replication. One is via HANA Studio. We can go inside Landscape and then go to System Replication. Using landscapeHostConfiguration.py Check the overall status of the primary system using as <sid>adm OS… Read More »

SQL Commands used for HANA database user

SQL Commands used for HANA database user The following sql command will show details for all sap hana users with deactivated status. Query: select USER_NAME, USER_DEACTIVATED from “SYS”.”USERS”; After executing the command, we will get below message: Statement ‘select USER_NAME, USER_DEACTIVATED from “SYS”.”USERS”‘ successfully executed in 247 ms 698 µs (server processing time: 0 ms… Read More »

S4 HANA Monitoring

Large and mid-market companies continue to adopt SAP to run their firms. The powerful SAP platform runs every aspect of a large enterprise from mission-critical lines of business all the way to administrative and supports services. For these firms, high availability is paramount; a system outage or performance degradation can cost millions of dollars. In… Read More »

Hana Database Not Starting due to Index Rebuilding

Issue: Hana Database Not Starting due to Index Rebuilding HANA DB Version : 96 Symptoms: We are facing issues in DB ,SAP HANA database not starting & System is currently down. Then DBA Finding’s : We can find trace at OS level at path: /hana/shared/<SID>/HDB<number>/hanaprd/trace Trace files are available in the SAP HANA Studio in… Read More »