Checking HANA DB replication status
From Notes_Wiki
Home > Suse > SAP setup and maintenance > Checking HANA DB replication status
The HANA database would have a ID such as ABC. In that case use following steps to check database replication status
- Login into both primary and secondary servers as root
- Connect to DB admin account on both machines using
- su - <abc>adm
- where <abc> should be replaced with HANA DB ID
- Check whether database is running using:
- HDB info
- sapcontrol -nr 00 -function GetProcessList
- We can get more help via 'sapcontrol -h'. Here '00' is the instance ID. If instance ID is 10 then use '-nr 10' instead, etc.
- 'HDB start' is used to start the DB and 'HDB stop' is used to stop the DB. These internally call sapcontrol appropriately to start/stop DB. See https://blogs.sap.com/2017/11/28/sap-hana-under-the-hood-hdb-by-the-sap-hana-academy/
- First we can check which machine is primary and which is secondary via:
- hdbnsutil -sr_state
- Then check replication status using:
- cd /usr/sap/<ABC>/HDB10/exe/python_support
- python systemReplicationStatus.py
- where <ABC> should be replaced with HANA DB ID
- In case of power architecture the folder where systemReplication.py is could be
- cd /hana/shared/<ABC>/exe/linuxppc64le/HDB_<version>/python_support
- where <version> is a long alphanumeric string
Home > Suse > SAP setup and maintenance > Checking HANA DB replication status