This document is about the Managed System Configuration of a HANA DB system.
I did managed system configuration of HANA DB system according to below link on Solution Manager 7.1 and used the same link for 7.2 version, too.
You will find short descriptions and practice of the configuration below. For more details and explanations use the wiki link.
Here are the steps performed for Managed System Configuration of HANA DB System.
Install Diagnostics Agent on HANA host
The first step is to install the Diagnostics Agent on the HANA servers.
You need latest SWPM and the Kernel DVDs for Linux. Also latest SAPEXE, SAPHOSTAGENT, SAPJVM and SAPDIAGNOSTICSAGENT SAR files as seen below.
Download them and transfer them to your HANA DB server.
I used MobaXterm tool for connecting to server and running sapinst.
If prerequisies are met there won’t be any “Condition not met” cases and you will install DAA on your HANA DB server successfully.
The parameters screens can be seen in previous blogs so I will not put them also in this document. If you want to have your agent’s SP levels latest you should enter the current archive locations as seen above in the last step of parameter entry.
After the istallation DAA Instance is registered to your Solution Manager. You can check it using the URL http://<solmanjavahostname>:<portnumber>/smd/AgentAdmin
Sometimes the servername of your DAA isn’t seen on the list. That time you can run below script to correct the name of your server.
Run the script smdsetup.bat changeservername servername:”evehrprd” in script folder as seen below.
Checking and Updating SAP Host Agent Version
When you install DAA instance SAPHOSTAGENT is also installed. Check the version using “saphostexec -version” script. You can see details in previous blogs of the series.
Since I have chosen the latest SAPHOSTAGENT*.SAR when I am installing DAA I donot need to upgrade Host Agent.
Creating Monitoring User in HANA
For Solution Manager connection you should create a HANA DB monitoring user.
Use HANA Studio to connect to DB and create the user and assign the roles MONITORING and PUBLIC to the user.
Use below SQL commands to make password of this user doesn’t have to be changed anymore.
ALTER USER <SID>MONITOR DISABLE PASSWORD LIFETIME;
CONNECT HRPMONITOR PASSWORD <password>;
Configure HDB User Store for SAP Host Agent
Login to system using <sid>adm.
Run below command to enable the SAP Host Agent to connect to HANA and can receive process information.
/usr/sap/hdbclient/hdbuserstore SET <SID>SAPDBCTRL <hana-master-host>:3<Sys-No>15 <SID>MONITOR password
Check the setup running below command:
/usr/sap/hdbclient/hdbuserstore LIST <SID>SAPDBCTRL
To check the setup there are some more commands that you can run. You can see the details in the mentioned wiki link at the top.
Register HANADB in SLD
Use HANA Platform Lifecycle Manager to register HANA in SLD:
Enter the SLD connection parameters as seen below.
And execute the registration process.
You can find HANA in the SLD of Solution Manager under Administration -> Content Maintenance -> HANA Database System:
You can also use HDBLCM tool to register HANA DB to SLD. You can see the details in wiki page.
Install HANA client software on SAP Solution Manager
If there is no HANA DB Client software installed on your Solution Manager before, download the client software and install it on your Solution Manager system. You can check the note 1597627 – SAP HANA connection for more.
Set DB parameter on Solution Manager
- Add X:\usr\sap\hdbclient path to the environment variable of Solution Manager sidadm user.
- Add “dbs/hdb/connect_property = DISTRIBUTION=OFF” parameter in the SAP Solution Manager DEFAULT.PFL profile.
- Restart Solution Manager System after these updates.
Call LMDB transaction on your Solution Manager System, select your HANA DB System.
Check that product version is supplied.
Check the SAP HANA DATABASE software is marked as Installed on Instance
Check that all of the HANA services can be seen under Technical Instances
From LMDB initial screen select your ABAP system and check that the DB of your system is your HANA DB.
Run Managed System Setup for HANA
From SOLMAN_SETUP transaction you choose your HANA DB system and select configure system as seen below.
1- Assign Product
In this step you define the product installed for the technical system.
Diagnostics-relevance is also set with product SAP HANA PLATFORM EDIT. 1.0.
2- Check Prerequisites
In this step, you check the prerequisites for the configuration of SAP Solution Manager automatically.
3- Assign Diagnostics Agent
In this step, you assign Diagnostics Agents to each server (host) on which managed systems are running. You can also check the status and version of the DAA.
4- Enter System Parameters
In this step, you specify the system parameters required to configure the managed system, which depend on the type of the managed system.
You specify the Introscope EM, Managed System Load Balancer Host and port. And enable EWA alert inbox and system recommendations.
You use the created HANA DB user in DB Parameters section and by saving you setup DBA Cockpit and DB extractors.
5- Enter Landscape Parameters
In this step, you can verify and add landscape parameters. Verify the landscape parameters carefully, to avoid time-consuming error-handling.
6- Finalize Configuration
There are automatic and manual activities that needs to be fulfilled in Final Configuration step. You can leave postponed activities as is. Fot manual activities got to each transactioon or URL to perform the activity.
7- Check Configuration
In this step, you automatically check whether the system is configured correctly, and you update the statuses in the overview of the Managed Systems Configuration.
This step provides an overview of the steps that have been performed in this scenario, including information about the users who made the changes, and the status of each step.
Managed System Configuration of a Busines Objects Cluster is coming next.
Thanks for your interests.