Monday, 9 April 2018

Create Resource Group and Resources in SAP HANA Cockpit 2.0 SP 06

As we are aware that SAP HANA Cockpit is the new web based HANA administration tool to monitor and manage HANA 2.0 databases, recently we installed the latest release SAP HANA Cockpit 2.0 SP 06 patch 04 for a client so as to monitor the BW/BPC HANA landscape.

To monitor and manage the HANA databases for the complete landscape, we installed HANA Cockpit 2.0 SP 06 patch 04 on a separate/dedicated server with 32 GB of RAM. Once the Cockpit instance is installed, we created resource groups and resources via SAP HANA Cockpit Manager web URL. A resource is the remote HANA database which we want to monitor via HANA Cockpit and a resource group is a group of commonly managed HANA databases for group level monitoring. For e.g. we planned to manage all BW/BPC non production HANA databases via a single resource group. So, we added all non production BPC HANA databases as ‘resources’ in the HANA cockpit and then we assigned these resources to the resource group.

I want to share how we configured the remote BW/BPC development HANA databases in HANA Cockpit Manager. A few prerequisites we should have in place before we configure resources:
1. HANA cockpit manager is accessible via URL https://fullhostname:510024

2. We are able to login the cockpit manager via the default cockpit user cockpit_admin or with our individual cockpit user created, for e.g., bsharma.

3. Logged in user (cockpit_admin or bsharma) should have the authorizations/roles such as Cockpit Resource Administrator and Cockpit User role.

Sequence of activities performed:

1. Create Resource Group
2. Register Resource
3. Assign the resource to a resource group
4. Validate resource monitoring via HANA Cockpit

Create a Resource Group:


Login SAP HANA Cockpit manager https://fullhostname:510024/ with Cockpit user.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

We will see the cockpit manager welcome screen. Only the features available according to the assigned authorizations, for e.g., to create a resource group and register a resource. Click on ‘Create Resource Group’ to create a resource group for group-level monitoring.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Enter the name for resource group according to the planned strategy to manage the customer landscape. For e.g. we created a group BW_BPC_NONPRD to monitor or manage all BW-BPC Non production HANA databases.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

There are no resources registered yet, so continue by clicking ‘Step 2’.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Click ‘add cockpit users’ button to browse available users.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Select the new cockpit user, for e.g. bsharma. This user will have access to the resource group BW_BPC_NONPRD so as to monitor and manage all the resources within the group.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Click the button – Create Group – to create the resource group.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Confirmation screen should display the details for new created resource group BW_BPC_NONPRD.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Register a Resource:


As we discussed before, a resource is the remote HANA database which we want to monitor and manage via SAP HANA Cockpit 2.0. Again login to cockpit manager and go to home page. Click on ‘Register a Resource’.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Select ‘System generated’ resource name. It will create a resource name for e.g. SID@SID in case of multiple container HANA database systems. Provide the details for the HANA database to be monitored and managed:

◈ Host: full hostname with domain
◈ Identifier: Instance Number (or port number)
◈ Container: Multiple Containers as our remote HANA database system is multi container. We selected – Tenant Database – so as to add the BW/BPC HANA development tenant database as resource to be monitored via HANA cockpit
◈ Database Name: Database name must be provided if we are trying to add a tenant database as a resource.
◈ Description: A short description for the remote HANA database we want to monitor

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Provide a technical user, a user which exists in the target remote HANA database. For e.g. we created a user COCKPIT_MONITORING in the tenant database. User should have minimum authorizations and can be created in the remote database using following SQL commands:

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Select whether to encrypt the connection or not. Check mark the options and continue to step 4.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Click – add group – to assign a particular resource group. So, the resource which we are trying to register will be a member of the resource group BW_BPC_NONPRD.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Select BW_BPC_NONPRD resource group, which we created before.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Continue with the selection after specifying the resource group.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Provide contact details for the person responsible for the resource/database and click Review.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Click the button – Register – to register the Resource.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

‘Resource Details’ will show the details about the registered resource. Remote HANA tenant database has been registered a resource GHC@GHC in SAP HANA Cockpit 2.0.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Validate the resource monitoring via SAP HANA Cockpit 2.0


We can click – Go to SAP HANA Cockpit – at the bottom of the screen from Cockpit Manager itself to go to HANA cockpit and to monitor the added resource. Or open SAP HANA Cockpit 2.0 via web URL http://fullhostname:510022

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Go to – Resources – to see the details for remote HANA tenant database. Resource state should be ‘Running’.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring

Click on Resource, for e.g. GHC@GHC, to monitor the resource / HANA tenant database.

SAP HANA Cockpit 2.0, SAP BW/4HANA, SAP HANA Database Monitoring