Skip to Content

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.

Create Monitor User.png

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:

                    LMDB Launch.png

      • Add the following product instances:

                      LMDB Definition.png

     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 setup wizard launch.png

      • Managed System Configuration -> Assign Diagnostics Agent:

Assign Agent.png

      • Managed System Configuration -> Enter System Parameters:

Enter System Parameters.png

      • Managed System Configuration -> Configure Automatically:

Automatic Configuration.png

      • Managed System Configuration -> Complete:

Finish.png

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.

Template Maintenance.png 

     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:

Define Scope.png

      • Apply and Activate the relevant template for HANA DB and the operating system:

Apply and Activate.png

Reporting.png

Finish_tech mon.png

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

To report this post you need to login first.

19 Comments

You must be Logged on to comment or reply to a post.

  1. David Hurst

    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.

    (0) 
    1. Bharath Kumar Post author

      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

      (0) 
  2. Thomas Dulaney

    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

    (0) 
    1. Bharath Kumar Post author

      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 🙂

      (0) 
      1. Thomas Dulaney

        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

        (0) 
  3. Patrick Gutheil

    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

    (0) 
    1. Bharath Kumar Post author

      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

      (0) 
      1. Patrick Gutheil

        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

        (0) 
  4. A. Diepeveen

    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.

    (0) 
  5. Chandrish Meganathan

    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

    (0) 
  6. Metin Katyap

    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

    (0) 
    1. Metin Katyap

      Hi Bharath,

      It has been resolved, next to Bharath’s explanation and “HANA Supportability and Monitoring Setup” gave my a clear view.

      Thx!

      Metin

      (0) 
  7. David Hurst

    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

    (0) 
  8. Raghu Padmanabula

    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

    (0) 

Leave a Reply