Hi everyone, HAPPY NEW YEAR 2015! It’s my first blog post/document in 2015. In this document, I want to share with you my experience setting up SAP DB Control Center with some notes and window dumps. Hope you can also set up your SAP DB Control Center successfully after reading this step-by-step tutorial.
Here I listed several related materials as follows. You can get an overview about SAP DB Control Center from the “What’s new” and the official “SAP DB Control Center 4 Guide” shows you how to set up SAP DB Control Center step by step. I just followed the official guide to set up my SAP DB Control Center. You can follow the official guide like me and consider this document as a reference; or you can follow this tutorial directly. It’s up to you.
- SAP HANA SPS 09 – What’s new? SAP DB Control Center
- SAP DB Control Center 4 Guide – PDF version
- SAP DB Control Center 4 Guide – HTML version
What’s SAP DB Control Center?
I just quoted some words and architecture diagrams from SAP HANA SPS 09 – What’s new? SAP DB Control Center, hoping you can get a basic idea about SAP DB Control Center. As introduced in SAP HANA SPS 09 – What’s new? SAP DB Control Center, you can regard the Cockpit as the cockpit of an airplane, while SAP DB Control Center plays the role like the control tower for air traffic.
SAP DB Control Center is SAP’s new-generation enterprise-class Systems Management solution that enables DBAs to Administer and Monitor a variety of SAP Database products in one graphical UI either locally or remotely.
The following diagram displays the hierarchy.
The current limitation is that SAP HANA multitenant database containers (MDC) is not supported.
OK. Here is my scenario. I have installed two SAP HANA SPS 09 rev. 91 single containers. Let’s name them system A and B. What I want to do is setting up SAP DB Control Center in one SAP HANA system (A) and monitoring another SAP HANA system (B). Now let’s start!
Setting up SAP DB Control Center
At the beginning of each step, I’ll first show on (which system, A or B) this step is carried out.
Step 1: Download SAP HANA DBCC delivery unit from Software Downloads | SAP Support Portal
Step 2: (A) Import SAP HANA DBCC delivery unit. After you import the DU successfully, you should be able to see the package sap.hana.dbcc
Step 3: (A) Configure xsengine.ini
- section scheduler: enabled=true Since SAP DB Control Center uses XS job scheduling to monitor the statuses of various databases, you need to enable the scheduler first.
- section httpserver: sessiontimeout=3600 It’s optional. You set this parameter in order to increase the time of session timeout.
Step 4: (A) Grant the following roles to the SYSTEM user
- sap.hana.dbcc.roles::DBCCAdmin (extends role sap.hana.dbcc.roles::DBCCUser)
Step 5: (A) Create the user DCC_ADM and grant the following roles. DCC_ADM is the administrator of SAP DB Control Center.
Step 6: (A) Create the user DCC_COLLECTOR and grant the following roles. DCC_COLLECTOR is in charge of collecting statuses of various databases.
Step 7: (A) Create the user DCC_USR and grant the following roles. DCC_USR is the user of SAP DB Control Center.
Step 8: (A) Grant application privileges to the role sap.hana.dbcc.roles::DBCCUser
2. Logon with the SYSTEM user
3. Select the role sap.hana.dbcc.roles::DBCCUser
4. In the “Catalogs” tab, assign the catalog “SAP DB CC”
5. In the “Groups” tab, assign the group “SAP DB Control Center”
Step 9: (A) In SAP HANA Studio, use “Add system with different user” to logon system A with new created users DCC_ADM, DCC_COLLECTOR and DCC_USR in order to change their passwords. You’ll be asked to change your password. It’s easy to understand and it’s the same in our daily life. Since SYSTEM (the administrator) created these users, SYSTEM knew their passwords. They need to change their passwords.
Step 10: (B) Create the technical user SAPDBCC in the monitored database and grant the following roles.
- sap.hana.admin.roles::Monitoring (This role is necessary for the cockpit)
On every SAP HANA system you will monitor with SAP DB Control Center, create an SAPDBCC user account, grant it monitoring privileges, and add the SAPDBCC account to the SQL connection configuration (SQLCC) in SAP HANA XS.
Step 11: (B) In SAP HANA Studio, use “Add system with different user” to logon system B with new created user SAPDBCC in order to change the password.
Step 12: (B) Configure dbccuser.xssqlcc (SQL connection configuration, can be used for anonymous connection)
2. Logon with the SYSTEM user (SYSTEM needs to have the role sap.hana.xs.admin.roles::SQLCCAdministrator)
3. Go to package sap.hana.admin.dbcc -> Select dbccuser.xssqlcc -> Input the username (SAPDBCC) and password -> Save
Step 13: (A) Add trust store
2. Logon with the SYSTEM user
3. Select “Trust Manager”
4. Add the trust store SAP_HANA_DBCC
Step 14: (A) Configure ScheduleCollections.xsjob, collect the APCA (Availability, Performance, Capacity, Alerts) data periodically. XSCron * * * * * * 0 means the job run every minute and, in addition, at the 0th second in the specified minute.
Select “XS Artifact Administration” -> Go to package sap.hana.dbcc.collections -> Select ScheduleCollections.xsjob -> Input username (DCC_COLLECTOR) and password -> Select “Active” -> Save Job
Step 15: (A) Configure Maintenance.xsjob, perform maintenance on the message queue periodically. XSCron * * * * * * 0 means the job run every minute and, in addition, at the 0th second in the specified minute.
Select “XS Artifact Administration” -> Go to package sap.hana.dbcc.maintenance -> Select Maintenance.xsjob -> Input username (DCC_COLLECTOR) and password -> Select “Active” -> Save Job
Step 16: (A) Access SAP DB Control Center
2. Logon with DCC_ADM
That’s it. Till now we’ve set up our SAP DB Control Center. In the next document Step by step tutorial – setting up SAP DB Control Center in SAP HANA SPS 09 (part 2), let’s have a look how to use SAP DB Control Center to start/stop/monitor databases.
Hope you enjoyed reading my tutorial and follow this document to set up your SAP DB Control Center successfully!