Status of Multi Node HANA applicance

[Former Member]

Hi all,

We have a multi node HANA applicance and 1 node is configured as standby , apart from the studio is the a OS command or a sql query which can tell if a particular node is running as a standby at the moment and the status of the other nodes 

Thank you

Jonu Joy

[Former Member]

Hi Jonu joy,

You can check the status of the HANA with the below command from OS level

./sapcontrol -nr 00 -function GetSystemInstanceList   

./sapcontrol -nr 00 -host "r2hana4-int" -function GetProcessList

Here is the SQL command to check the status of the standby host

select host,host_active,nameserver_actual_role,indexserver_actual_role from m_landscape_host_configuration  

Regards,

B.Srinath