Configure SAP Solution Manager for RCA tools and Technical Monitoring of HANA DB
Preparation of Solution Manager:
1) SAP Notes implemented on Solution Manager:
SAP Note 1612172 – HDB: Solution Manager Setup Wizard Integration
2) Install hdbclient on solution manager: (SAP Note 1597627)
Uncar the SAR file downloaded from SAP Service Market Place.
Run command: hdbinst -a client -p /usr/sap/<SID>/hdbclient to install the hdbclient.
4) Set PATH variable to hdbclient installation location. (/usr/sap/<SID>/hdbclient)
Preparation on HANA:
1) Create a user called MONITOR with Monitoring role using HANA studio.
2) Install Diagnostics agent version 7.3 which includes SAP Host agent as part of the installation.
3) Upgrade SAP Host Agent to minimum patch 84.
4) Connect HANA DB to LMDB: (assume SID of HANA DB as HDB for the following steps)
a) Configuration the hdbuserstore (SAP Note 1625203)
- run as hdbadm -> /usr/sap/hdbclient/hdbuserstore SET HDBSAPDBCTRL <hostname>:3$$15 MONITOR <password>
- 3$$15 –> $$ stands for instance number of HANA DB installation
- run as hdbadm -> /usr/sap/hdbclient/hdbuserstore LIST HDBSAPDBCTRL
- run as root -> set environment variable LD_LIBRARY_PATH=/usr/sap/hostctrl/exe
- This is to give saphost agent permission to access DB monitoring.
- run as root -> /usr/sap/hostctrl/exe/sapdbctrl status HDB -t hdb
b) Outside Discovery and Alerting
- run as root -> /usr/sap/hostctrl/exe/saphostctrl -function GetDatabaseProperties -dbname HDB -dbtype hdb
- This is for sap host agent outside discovery of HANA DB.
c) Status: Webmethod GetDatabaseStatus
- run as root -> /usr/sap/hostctrl/exe/saphostctrl -function GetDatabaseStatus -dbname HDB -dbtype hdb
RCA Setup: Managed System Configuration:
Run Managed System Configuration wizard for HANA DB:
a) Assign software for HANA DB in LMDB.
- Launch LMDB and select maintain HANA DB:
- Add the following product instances:
b) Complete Managed System Configuration for HANA DB:
- Launch the configuration wizard for HANA DB by launching it under the Databases tab of Managed Systems Configuration Wizard:
- Managed System Configuration -> Assign Diagnostics Agent:
- Managed System Configuration -> Enter System Parameters:
- Managed System Configuration -> Configure Automatically:
- Managed System Configuration -> Complete:
Activate Technical Monitoring for HANA DB:
a) Customize and Modify the Technical Monitoring Template provided for HANA DB. Template for HANA DB is available as of Content version 7.
b) Assign and Activate the relevant template for HANA DB:
- Launch the configuration wizard for HANA DB by launching it under the Database tab of Technical Monitoring:
Select the HANA DB under Scope:
- Apply and Activate the relevant template for HANA DB and the operating system:
Appendix:
In order to monitor HANA DB with Solution Manager, the minimum version requirement is to have SAP Solution Manager 7.1 SP 02.
What can be monitored:
| HANA DB Version | Solution Manager Version | What is available |
|---|---|---|
| SP 03 | 7.1 SP 02 – 7.1 SP 04 | E2E DB Analysis – Yes E2E Trace Analysis – No Technical Monitoring and Alerting – Yes (starting from Solution Manager 7.1 SP 04) |
| SP 04 | 7.1 SP 02 – 7.1 SP 04 |
E2E DB Analysis – Yes |
| SP 03 | > 7.1 SP 05 |
E2E DB Analysis – Yes |
| SP 04 | > 7.1 SP 05 |
E2E DB Analysis – Yes |
Step 4a, bullet one seems to contradict SAP Note 1625203.
SCN Blog:
hdbuserstore SET HDBSAPDBCTRL <hostname>:3$$15 MONITOR <password>
SAP Note 1625203:
hdbuserstore SET <SID>SAPDBCTRL <dbhost>:<port> SAPDBCTRL <password>
Please advise.
Hello David,
In the SAP Note, the user that is created itself is named as SAPDBCTRL whereas in my example, i have created the user called MONITOR. Hence i write the command with MONITOR user instead of SAPDBCTRL.
If you use the format given in the note and create the user called SAPDBCTRL, use the same user in the command prompt as well.
Regards,
Bharath
Thanks Bharath. That fixed it.
The potential here is so exciting to me! I hate to ask about the money, but...
Is there a licensing cost to use HANA with Solution Manager?
Best regards,
--Tom
Tom, this is not installing solution manager on HANA. Installation of Solution Manager on HANA is planned in the future, but dont know the timelines yet.
This blog addresses monitoring HANA DB with solution manager. for this, there is no license restriction. You just need to have a HANA DB to monitor using Solution Manager 🙂
Dooh! That's what I get for skimming. I saw what I wanted to see, which is HANA under Solution Manager. Is there any information about whether or not licensing will be required to run HANA under Solution Manager? We have interest but no budget to implement HANA under BW at my customer. We could prove out the concepts of HANA on Solution Manager and provide more fuel to the Cost/Benefit Analysis if we could move forward with HANA under SolMan with no license cost.
I'm guessing we're too early to know. If so, just file this under "Really, really hope it works this way..." 🙂
Best regards,
--Tom
Hello Bharath,
if we try to execute...
/usr/sap/hostctrl/exe/saphostctrl -function GetDatabaseProperties -dbname HQA -dbtype hdb
...we get this error:
*** ERROR => 'Get all database properties' failed: Generic error [sapdbctrl.cp 2555]
In use:
Hana DB Version 31
Diagnostic Agent 7.3 SP 02
Solution Manager 7.1 SP 05
Best regards,
Patrick
Hello Patrick,
The issue can be caused by an old version of the SAPHOSTAGENT. Upgrade it to the latest available patch level and retry.
Regards,
Bharath
The latest saphostagent doesn't solve the issue.
Info: Retrieve version info: SAPHOSTAGENT information
Info: Retrieve version info: --------------------
Info: Retrieve version info: kernel release 720
Info: Retrieve version info: kernel make variant 720_REL
Info: Retrieve version info: compiled on Linux GNU SLES-9 x86_64 cc4.1.2 for linuxx86_64
Info: Retrieve version info: compiled for 64 BIT
Info: Retrieve version info: compilation mode Non-Unicode
Info: Retrieve version info: compile time Jun 30 2012 00:54:37
Info: Retrieve version info: patch number 112
Info: Retrieve version info: latest change number 1340978
Have you installed HDB client on solution manager system as well?
Yes, but the issue is on the HDB host.
I had today the same issue. I recently upgraded our SAP HANA to SPS05 were te hostagent installation was originaly performed on SPS04. After setting tracelevel to 3 I found out that libsapdbhdbctrl.so was unable to handle all requests. After updating the hostagent to a patchlevel newer than SPS05 (latest available) the issue was solved.
very good short summary and step list - easy to follow
Hi Bharath,
I am getting issues while executing following commands,.
1) /usr/sap/hostctrl/exe/sapdbctrl status HDB -t hdb
Result : Aborted
2) /usr/sap/hostctrl/exe/saphostctrl -function GetDatabaseProperties -dbname HDB -dbtype hdb
Result: Command execution failed.
I have a latest host agent installed on my system.
Please have a look into this issue.
Regards,
Chandrish M
Hi Bharath,
I am getting issues while executing commands at 4b, sapdbctrl status HDB -t hdb.
ERROR: Database software not installed, nevertheless I can access the HANA with studio where the services are up and running...
If this a seqeuntial process of the installation procedure I cannot proceed further, any help would be appriciated.
Thx in advance!
Metin
Hi Bharath,
It has been resolved, next to Bharath's explanation and "HANA Supportability and Monitoring Setup" gave my a clear view.
Thx!
Metin
How exactly have you solved it? I've latest saphostagent, still getting this error.
When I execute:
/usr/sap/hostctrl/exe/saphostctrl -function GetDatabaseProperties -dbname HDB -dbtype HDB, I get the following error:
Error: getDBSysBit: Unsupported plattform.
Any advice? This does not occur on our other HDB systems and they were installed using the same media/process.
/Dave
Hi,
We have created Monitor user and ran the command below to update hdbuserstore
/usr/sap/hdbclient/hdbuserstore SET <SID>SAPDBCTRL <hostname>:3$$15 MONITOR <password>
But after that if I run get db status command it says invalid user/password. I have confusion here.
Do we need to use key always as <SID>SAPDBCTRL or it should like <SID>Username?
Could you please clarify?
BR,
Raghu