Symptom
Facing issue on HANA hosts, where have replication active.
If the sldreg.xml is generated, it does not put this file onto the trace folder of the secondary database host.
This seems to cause that the replication relationship do not get to SLD and Solman for monitoring.
Using instruction in SAP Note#2436986 with special focus on SLD Registration for SAP HANA System Replcation systems.
If all settings are in place, the sldreg.xml file will be generated in the /hana/shared/<SID>/HDB<nr>/<hostname>/trace folder of both system (primary and secondary host):
sldreg -connectfile /usr/sap/<SID>/SYS/global/slddest.cfg -file /hana/shared/<SID>/HDB<instance number>/<hostname>/trace/sldreg.xml
It succeed on the primary host, but the sldreg.xml file is not created on the secondary system.
On the SLD trace of primary and secondary, it show that the payload file sldreg.xml was created and sent to SLD:
nameserver_s-zyxwv-2-8x.31001.000.trc
[26133]{-1}[-1/-1] 2022-03-09 15:31:11.978299 d SLDCollect CIMModel.cpp(02970) : ComponentOnComputerSystem: HDB_CLIENT
[26133]{-1}[-1/-1] 2022-03-09 15:31:11.978971 i SLDSend Sld.cpp(00388) : SldReg xml=/usr/sap/ABC/HDB10/s-zyxwv-2-8x/trace/sldreg.xml, log=/usr/sap/ABC/HDB10/s-zyxwv-2-8x/trace/sldreg.log, cfg=/usr/sap/ABC/SYS/global/slddest.cfg
[26133]{-1}[-1/-1] 2022-03-09 15:31:12.162771 i Basis ProcessExecution.cpp(00859) : Child process exited: 0, "sldreg" "-connectfile" "/usr/sap/ABC/SYS/global/slddest.cfg" "-file" "/usr/sap/ABC/HDB10/s-zyxwv-2-8x/trace/sldreg.xml" "-logfile" "/usr/sap/ABC/HDB10/s-zyxwv-2-8x/trace/sldreg.log"
nameserver_s-zyxwv-1-o1.31001.004.trc
[29701]{-1}[-1/-1] 2022-03-09 14:49:26.798673 d SLDCollect CIMModel.cpp(02970) : ComponentOnComputerSystem: HDB_CLIENT
[29701]{-1}[-1/-1] 2022-03-09 14:49:26.799662 i SLDSend Sld.cpp(00388) : SldReg xml=/usr/sap/ABC/HDB10/s-zyxwv-1-o1/trace/sldreg.xml, log=/usr/sap/ABC/HDB10/s-zyxwv-1-o1/trace/sldreg.log, cfg=/usr/sap/ABC/SYS/global/slddest.cfg
[29701]{-1}[-1/-1] 2022-03-09 14:49:26.923800 i Basis ProcessExecution.cpp(00859) : Child process exited: 0, "sldreg" "-connectfile" "/usr/sap/ABC/SYS/global/slddest.cfg" "-file" "/usr/sap/ABC/HDB10/s-zyxwv-1-o1/trace/sldreg.xml" "-logfile" "/usr/sap/ABC/HDB10/s-zyxwv-1-o1/trace/sldreg.log"
Read more...
Environment
SAP HANA DB 2.0
Product
Keywords
KBA , HAN-DB-MON , SAP HANA Monitoring , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.