SAP DB Control Center (DCC) is a web-based database monitoring and administration tool for SAP HANA that was introduced in the SPS09 release. With DCC, you can monitor and administer a landscape of SAP HANA databases (i.e. two or more instances). It allows database administrators and IT management teams to view alerts and database health information at a single glance.
As the product evolves from its initial release and customer adoption increases, I've started to see situations where the DCC system may not behave as expected, typically because something is missing or incorrect in the system's configuration. In this blog post, I'm going to list a number of issues that can occur and how to resolve them.
This problem occurs when the DCC_COLLECTOR account (user that runs collection jobs to gather health data for each monitored system) doesn't have the correct role assigned to it. What you see is the number of systems displayed in the Monitor Enterprise Health tile is either zero or one:
The correct role to assign to the DCC_COLLECTOR account is "DBCCCollector" (that's in addition to the "Monitoring" role). Note that this applies to DCC revision 93 (Patch 7) or higher. In the earlier revisions, the role was "DBCCAdmin", but that is now solely used for the DCC_ADM account.
All you need to do is assign the "DBCCCollector" role to the DCC_COLLECTOR account using SAP HANA Studio or the Web-based Development Workbench:
After waiting a few minutes, you'll see the number of systems in the Monitor Enterprise Health tile increase, meaning that health data is now being collected.
You exhibit this issue when the Enterprise Health Monitor displays the question mark icon (?) for Availability, Performance and Capacity in all systems except for one (the DCC system):
There's a few XS jobs that must be active by the DCC_COLLECTOR account to collect the enterprise health data and maintain the message queue. To see the status of these jobs, open the SAP HANA XS Administration tool:
http://<dcc_system_host>:<dcc_system_port>/sap/hana/xs/admin/jobs
Login as SYSTEM and ensure the user for the DCC jobs JobWorkerTask, Maintenance and ScheduleCollections is DCC_COLLECTOR, their status is ACTIVE, and their last run status is SUCCESS. For example, in the following screenshot, we see that JobWorkerTask is not assigned a user and is not active:
To fix the problem, click on the XS Job name, then click on the Configuration tab. Now provide the DCC_COLLECTOR user account credentials, check the Active checkbox and click Save the bottom right corner of the page:
After the job is saved successfully, you can return to the XS Job Dashboard page and you'll now notice that all the DCC jobs have DCC_COLLECTOR as their user, their status is ACTIVE and their last run status is SUCCESS. Wait a few minutes and go back to Monitor Enterprise Health in DCC and you'll see that the health data for your systems is now collected.
You'll see this issue when the status of the system displays "Running" but you see question marks (?) for its Availability, Capacity and Performance.
This problem can happen for one of the following reasons:
A series of steps need to be performed when upgrading from DCC SPS09 to DCC SPS10 (but only in that scenario). Please follow the steps described in SAP Note 2188247
Screenshots of the procedure are located here: Upgrading SAP DB Control Center from SPS09 to SPS10.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
38 | |
19 | |
14 | |
12 | |
10 | |
10 | |
10 | |
8 | |
8 | |
8 |