Skip to Content

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.

Related materials

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.

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.

1.PNG

2.PNG

The current limitation is that SAP HANA multitenant database containers (MDC) is not supported.

Scenario

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

/wp-content/uploads/2014/12/3__617361.png

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

/wp-content/uploads/2014/12/4__617427.png

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.

/wp-content/uploads/2014/12/5__617428.png

Step 4: (A) Grant the following roles to the SYSTEM user

  • sap.hana.dbcc.roles::DBCCAdmin (extends role sap.hana.dbcc.roles::DBCCUser)
  • sap.hana.uis.db::SITE_DESIGNER
  • sap.hana.xs.admin.roles::HTTPDestAdministrator
  • sap.hana.xs.admin.roles::JobAdministrator
  • sap.hana.xs.admin.roles::RuntimeConfAdministrator
  • sap.hana.xs.admin.roles::SQLCCAdministrator
  • sap.hana.xs.admin.roles::TrustStoreAdministrator

/wp-content/uploads/2014/12/6__617457.png

Step 5: (A) Create the user DCC_ADM and grant the following roles. DCC_ADM is the administrator of SAP DB Control Center.

  • sap.hana.admin.roles::Monitoring
  • sap.hana.dbcc.roles::DBCCAdmin

/wp-content/uploads/2014/12/7__617458.png

Step 6: (A) Create the user DCC_COLLECTOR and grant the following roles. DCC_COLLECTOR is in charge of collecting statuses of various databases.

  • sap.hana.admin.roles::Monitoring
  • sap.hana.dbcc.roles::DBCCAdmin

/wp-content/uploads/2014/12/8__617462.png

Step 7: (A) Create the user DCC_USR and grant the following roles. DCC_USR is the user of SAP DB Control Center.

  • sap.hana.admin.roles::Monitoring
  • sap.hana.dbcc.roles::DBCCUser

/wp-content/uploads/2014/12/9__617463.png

Step 8: (A) Grant application privileges to the role sap.hana.dbcc.roles::DBCCUser

1. Visit http://<hostname>:<port>/sap/hana/uis/clients/role-editor/RoleEditor.html?scenario=onPremise

2. Logon with the SYSTEM user

3. Select the role sap.hana.dbcc.roles::DBCCUser

/wp-content/uploads/2014/12/10__617465.png

4. In the “Catalogs” tab, assign the catalog “SAP DB CC”

/wp-content/uploads/2014/12/11_617466.png

5. In the “Groups” tab, assign the group “SAP DB Control Center”

/wp-content/uploads/2014/12/12_617467.png

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.

/wp-content/uploads/2014/12/13__617468.png

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.

/wp-content/uploads/2014/12/14__617469.png

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.

/wp-content/uploads/2014/12/13__617468.png

Step 12: (B) Configure dbccuser.xssqlcc (SQL connection configuration, can be used for anonymous connection)

1. Visit http://<hostname>:<port>/sap/hana/xs/admin/

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

/wp-content/uploads/2014/12/15__617474.png

Step 13: (A) Add trust store

1. Visit http://<hostname>:<port>/sap/hana/xs/admin/

2. Logon with the SYSTEM user

3. Select “Trust Manager”

4. Add the trust store SAP_HANA_DBCC

/wp-content/uploads/2014/12/16__617476.png

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

/wp-content/uploads/2014/12/17__617480.png

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

/wp-content/uploads/2014/12/18__617481.png

Step 16: (A) Access SAP DB Control Center

1. Visit http://<hostname>:<port>/sap/hana/dbcc

2. Logon with DCC_ADM

/wp-content/uploads/2014/12/19__617482.png


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!

To report this post you need to login first.

8 Comments

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

  1. Jose Ramos

    Hi Wenjun,

    Great tutorial!  I want to point out that as of DCC PL7 (Revision 93), there’s a new role called “DBCCCollector” for the DCC_COLLECTOR user.  In the steps above, that affects step 6 as the DBCCAdmin role is now only for the DCC_ADM user.

    Also step 7 is no longer required as of DCC PL7 (Rev 93).

    (0) 
  2. Nuno Lopes Almeida

    Hi,

    thx for sharing. Where can I find more information about “how to add new system” to my dbcc? Is it necessary to install the Delivery unit SAPDBCC on the new system or only create one user with the respective role and open the ports?

    thx in advance

    Nuno

    (0) 
  3. Yuksel AKCINAR

    Hello Wenjun,

    I configured SAP DB Control Center according to your blog and ¬†Denys‘s HANA Academy video.

    There is info about adding an ASE System to DBCC on¬†SAP DB Control Center 4 Guide but it dows not work for our ASE system which is SAP PO system’s DB. Our ASE system is using 4901-4904 ports.

    Mentioned document tells to use port 4283 default port for ASE systems.

    SAP ASE   Cockpit port   4283 (the default)

    But either or the ports (4283,4901,4902,4903,4904) work for adding the ASE system to DBCC. System gives “No systems were found for registration Resource scan failed Bad Request”

    There is not problem for HANA DBs.

    Can you (all) tell me how to add an ASE system to DB Control Center, please?

    Is there a document for this?

    Regards,

    Yuksel AKCINAR

     

    (0) 

Leave a Reply