I have run the suggested command with OS admin at the console and here is the result: (as in my current situation - here I have a seriosu limitation - not allowed to upload files)
Aside of the fact that there is no replication defined - I do not see any flaw in output.
Maybe the SAP admin failed to mention that there is nothing to monitor yet?
- shift
- test -n 2
- case “$1” in
- shift
- test -n ‘’
- ‘[’ -e /etc/check_mk//sap_hana.cfg ‘]’
- . /etc/check_mk//sap_hana.cfg
++ USERSTOREKEY=usercensored - ‘[’ -z usercensored ‘]’
- ps -efw
- grep ‘[H]DB.*sapstartsrv’
- read -r line
++ echo ‘admcensored 6806 1 0 Nov18 ? 00:00:27 /usr/sap/SIDcensored/HDB00/exe/sapstartsrv pf=/usr/sap/SIDcensored/SYS/profile/SIDcensored_HDB00_censored -D -u admcensored’
++ sed ‘s/./(.)/./exe/sapstartsrv./\1/g’ - SID=SIDcensored
++ echo ‘admcensored 6806 1 0 Nov18 ? 00:00:27 /usr/sap/SIDcensored/HDB00/exe/sapstartsrv pf=/usr/sap/SIDcensored/SYS/profile/SIDcensored_HDB00_censored -D -u admcensored’
++ sed -e ‘s/./(.)/exe/sapstartsrv.*/\1/g’ -e ‘s/[^0-9]//g’ - INSTANCE=00
++ echo ‘admcensored 6806 1 0 Nov18 ? 00:00:27 /usr/sap/SIDcensored/HDB00/exe/sapstartsrv pf=/usr/sap/SIDcensored/SYS/profile/SIDcensored_HDB00_censored -D -u admcensored’
++ grep -Po ‘^\s*(\w+)’ - INSTANCE_USER=admcensored
- ‘[’ -z 00 ‘]’
- ‘[’ -z SIDcensored ‘]’
- do_query SIDcensored 00 admcensored
- local SID=SIDcensored
- local INSTANCE=00
- local INSTANCE_USER=admcensored
- local HOSTNAME
- local ‘INSTANCE_NAME=[[SIDcensored 00]]’
- local SAP_LANDSCAPE
++ su - admcensored -c ‘python /usr/sap/SIDcensored/HDB00/exe/python_support/landscapeHostConfiguration.py’ - SAP_LANDSCAPE=’| Host | Host | Host | Failover | Remove | Storage | Storage | Failover | Failover | NameServer | NameServer | IndexServer | IndexServer | Host | Host | Worker | Worker |
| | Active | Status | Status | Status | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual |
| | | | | | Partition | Partition | Group | Group | Role | Role | Role | Role | Roles | Roles | Groups | Groups |
| ---------- | ------ | ------ | -------- | ------ | --------- | --------- | -------- | -------- | ---------- | ---------- | ----------- | ----------- | ------ | ------ | ------- | ------- |
| censored | yes | ok | | | 1 | 1 | default | default | master 1 | master | worker | master | worker | worker | default | default |
overall host status: ok’
- ‘[’ -z ‘’ ‘]’
++ sap_hana_host_from_landscape '| Host | Host | Host | Failover | Remove | Storage | Storage | Failover | Failover | NameServer | NameServer | IndexServer | IndexServer | Host | Host | Worker | Worker |
| | Active | Status | Status | Status | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual |
| | | | | | Partition | Partition | Group | Group | Role | Role | Role | Role | Roles | Roles | Groups | Groups |
| ---------- | ------ | ------ | -------- | ------ | --------- | --------- | -------- | -------- | ---------- | ---------- | ----------- | ----------- | ------ | ------ | ------- | ------- |
| censored | yes | ok | | | 1 | 1 | default | default | master 1 | master | worker | master | worker | worker | default | default |
overall host status: ok’
++ local 'landscape=| Host | Host | Host | Failover | Remove | Storage | Storage | Failover | Failover | NameServer | NameServer | IndexServer | IndexServer | Host | Host | Worker | Worker |
| | Active | Status | Status | Status | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual |
Partition | Partition | Group | Group | Role | Role | Role | Role | Roles | Roles | Groups | Groups | |||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
censored | yes | ok | 1 | 1 | default | default | master 1 | master | worker | master | worker | worker | default | default |
overall host status: ok’
++ local col_hosts=1
++ local row_hosts_start=5
++ local cur_row=1
++ local cur_hostname
++ local cur_IP
++ read -r line
++ [[ | != | ]]
+++ echo ‘| Host | Host | Host | Failover | Remove | Storage | Storage | Failover | Failover | NameServer | NameServer | IndexServer | IndexServer | Host | Host | Worker | Worker |’
+++ sed -e ‘s/^|//’
++ line=’ Host | Host | Host | Failover | Remove | Storage | Storage | Failover | Failover | NameServer | NameServer | IndexServer | IndexServer | Host | Host | Worker | Worker |’
++ ‘[’ 1 -ge 5 ‘]’
++ cur_row=2
++ read -r line
++ [[ | != | ]]
+++ echo ‘| | Active | Status | Status | Status | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual |’
+++ sed -e ‘s/^|//’
++ line=’ | Active | Status | Status | Status | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual |’
++ ‘[’ 2 -ge 5 ‘]’
++ cur_row=3
++ read -r line
++ [[ | != | ]]
+++ echo ‘| | | | | | Partition | Partition | Group | Group | Role | Role | Role | Role | Roles | Roles | Groups | Groups |’
+++ sed -e ‘s/^|//’
++ line=’ | | | | | Partition | Partition | Group | Group | Role | Role | Role | Role | Roles | Roles | Groups | Groups |’
++ ‘[’ 3 -ge 5 ‘]’
++ cur_row=4
++ read -r line
++ [[ | != | ]]
+++ echo ‘| ---------- | ------ | ------ | -------- | ------ | --------- | --------- | -------- | -------- | ---------- | ---------- | ----------- | ----------- | ------ | ------ | ------- | ------- |’
+++ sed -e ‘s/^|//’
++ line=’ ---------- | ------ | ------ | -------- | ------ | --------- | --------- | -------- | -------- | ---------- | ---------- | ----------- | ----------- | ------ | ------ | ------- | ------- |’
++ ‘[’ 4 -ge 5 ‘]’
++ cur_row=5
++ read -r line
++ [[ | != | ]]
+++ echo ‘| censored | yes | ok | | | 1 | 1 | default | default | master 1 | master | worker | master | worker | worker | default | default |’
+++ sed -e ‘s/^|//’
++ line=’ censored | yes | ok | | | 1 | 1 | default | default | master 1 | master | worker | master | worker | worker | default | default |’
++ ‘[’ 5 -ge 5 ‘]’
+++ echo ’ censored | yes | ok | | | 1 | 1 | default | default | master 1 | master | worker | master | worker | worker | default | default |’
+++ awk -F ‘|’ ‘{print $col}’ col=1
+++ sed -e ‘s/^[[:space:]]//’ -e 's/[[:space:]]$//’
++ cur_hostname=censored
++ [[ -z censored ]]
+++ nslookup censored
+++ grep Address
+++ grep -v ‘#’
+++ awk ‘{print $2}’
++ cur_IP=
++ [[ -z ‘’ ]]
++ continue
++ read -r line
++ [[ ‘’ != | ]]
++ break
- HOSTNAME=
+++ query_sap_hana_status
+++ cat
++ mk_hdbsql SIDcensored 00 admcensored ‘SELECT Name, Status, Value FROM M_SYSTEM_OVERVIEW Where NAME=’’‘Version’’’ or
NAME=’’‘All Started’’’’
++ local sid=SIDcensored
++ local instance=00
++ local instance_user=admcensored
++ local query
+++ echo ‘SELECT Name, Status, Value FROM M_SYSTEM_OVERVIEW Where NAME=’’‘Version’’’ or
NAME=’’‘All Started’’’’
+++ tr ‘\n’ ’ ’
++ query=‘SELECT Name, Status, Value FROM M_SYSTEM_OVERVIEW Where NAME=’’‘Version’’’ or NAME=’’‘All Started’’’ ’
++ local credentials
++ local hdbsql_path=/usr/sap/SIDcensored/HDB00/exe/hdbsql
++ ‘[’ -n usercensored ‘]’
++ credentials=’-U usercensored’
++ ‘[’ ‘’ = agent ‘]’
+++ su - admcensored -c ‘/usr/sap/SIDcensored/HDB00/exe/hdbsql -C -F; -x -a -n localhost -i 00 -U usercensored "SELECT Name, Status, Value FROM M_SYSTEM_OVERVIEW Where NAME=’’‘Version’’’ or NAME=’’‘All Started’’’ "’
++ result=
++ rc=3
++ echo ‘’
++ sed -e ‘s/^;//’ -e ‘s/;$//’
++ return 3 - status_output=
- echo ‘<<<sap_hana_replication_status>>>’
<<<sap_hana_replication_status>>> - echo ‘[[SIDcensored 00]]’
[[SIDcensored 00]] - sap_hana_replication_status SIDcensored 00 admcensored
- local sid=SIDcensored
- local instance=00
- local instance_user=admcensored
++ su - admcensored -c ‘python /usr/sap/SIDcensored/HDB00/exe/python_support/systemReplicationStatus.py’ - result=‘this system is not a system replication site’
- echo ‘systemReplicationStatus: 10’
systemReplicationStatus: 10 - echo ‘this system is not a system replication site’
this system is not a system replication site - ‘[’ -v PASSWORD_CONNECT ‘]’
- read -r line