Configure SAP Solution Manager for RCA tools and Technical Monitoring of HANA DB

[Former Member]

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 E2E Trace Analysis - Yes Technical Monitoring and Alerting - Yes (starting from Solution Manager 7.1 SP 04)
SP 03	> 7.1 SP 05	E2E DB Analysis - Yes E2E Trace Analysis - Yes Technical Monitoring and Alerting - Yes
SP 04	> 7.1 SP 05	E2E DB Analysis - Yes E2E Trace Analysis - Yes Technical Monitoring and Alerting - Yes