Difference between revisions of "Checking HANA DB replication status"

Revision as of 05:38, 21 July 2022

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
```
We can get more help via 'sapcontrol -h'

'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

@@ Line 25: / Line 25: @@
 #:</pre>
 #: where &lt;ABC&gt; should be replaced with HANA DB ID
+#: In case of power architecture the folder where systemReplication.py is could be
+#::<pre>
+#::: cd /hana/shared/<ABC>/exe/linuxppc64le/HDB_<version>/python_support
+#::</pre>
+#: where &lt;version&gt; is a long alphanumeric string
 [[Main Page|Home]] > [[Suse]] > [[SAP setup and maintenance]] > [[Checking HANA DB replication status]]