The SAP HANA database system is not available through the SQL interface. Which options do you have to collect information to monitor connections, transactions, blocked transactions, and threads? Note: There are 2 correct answers to this question.
Answer is C, D
The Troubleshoot Unresponsive Systems function uses the SAP host agent. It can collect the most important diagnosis information from the SAP HANA database, even when the system is stopped or cannot be reached by SQL due to performance problems.
To troubleshoot a system in a hang state, there is a function in SAP HANA cockpit called Troubleshoot unresponsive systems. When using this function, information is collected through the SAP host agent. The communication between the web browser and the SAP host agent is always done over HTTPS, which requires that the SAP host agent has a Secure Sockets Layer (SSL) certificate (PSE) in its security directory.
The information is collected into a file named emergency_info_.zip by the Python script emergencyInfo.py. This script connects to the index server, using the hdbcons interface. The script tries to collect information about the open connections, running transactions, and threads. It also shows blocked transactions. If the index server is unavailable, no information is shown.
upvoted 1 times
...
Log in to Pass4Success
Sign in:
Report Comment
Is the comment made by USERNAME spam or abusive?
Commenting
In order to participate in the comments you need to be logged-in.
You can sign-up or
login
Joan Antonio Perez Moreno
1 years ago