Skip to Content
Author's profile photo Denys van Kempen

SAP HANA 2.0 SPS 02 What’s New: SAP HANA Cockpit – by the SAP HANA Academy

Introduction

In the last couple of weeks, we have posted new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA 2.0 Support Package Stack (SPS) 02.

The topic of this blog is the SAP HANA cockpit 2.0 SP 03 and it is the last blog of this series.

For the previous version of this blog, see

For the full SAP HANA 2.0 SPS 02 blog list, see

Tutorial Video

So far in this series, we have discussed Platform Lifecycle Management (Installation and Update), Security, System Administration, High Availability, Database Backup and Recovery, and Application Lifecycle Management. For most of the topics, SAP HANA cockpit was in the limelight.

To avoid showing the same features again in a dedicated video tutorial about SAP HANA cockpit, I will list the features below and point to the relevant video tutorial.

There are new features for:

  • System Administration
  • Performance Monitoring and Analysis
  • Security Administration
  • High Availability and Scalability
  • Backup and Recovery
  • Database Explorer

System Administration

SAP HANA cockpit for offline administration EOL?

The tool “SAP HANA cockpit for offline administration”, hosted by the SAP host agent, was introduced with SPS 11 to cover functionality that could not be provided by the regular SAP HANA cockpit tool, hosted, as it was, by the SAP HANA system itself.

As with SAP HANA 2.0, the cockpit is no longer part of a HANA system, this offline tool is no longer required. All the offline capabilities have now been brought into the SAP HANA cockpit 2.0 (online).

The tool has not yet been removed but you may want to start to prepare yourself that some day, yes alas, it may no longer be with us (or, at the least, incarnates as an undocumented feature like HDB admin).

OLD
NEW

Resource Management in Cockpit Manager

To facilitate resource registrations between SAP HANA cockpit systems, you can now import and export resources in cockpit manager.

Multitenant Database Container System Management

Restricted features, blacklisted parameters, workload allocation, and auto-restart configuration are now all available from the Manage Databases page.

System Health

The System Health app for multi-host systems has been enhanced with additional functionality.

 

For the detailed blog about this topic, see

For the video tutorial, see

Performance Monitoring and Analysis

Performance Monitor (Changed)

On the Performance Monitor page, you can now drill-in to the selected time range.

Threads (Changed)

On the Threads page, you can now identify what transaction is blocking a statement in a dedicated column.

Capture and Replay (Changed)

On the Replay Configuration page, you can now set optional filters (for example, statement type) and select more than one replayer.

Workload Analyzer (Changed)

You now have the possibility with Workload Analysis (thread samples) to export and import datasets. This enables you to store the data in an application and to analyze it in another system.

For Workload Analyzer (engine instrumentation) you can now set specific filters (for example, statement hash, thread type, or application source).

Security Administration

Database User and Role Management (Changed)

If you are implementing user authorization based on LDAP group membership, you can now set the authorization mode of a user to LDAP on the New User page.

Encryption Configuration and Encryption Key Management (New)

You can now view the status and enable Data Encryption on the Overview page for not only data volume but also for Log Volume and Backup Encryption.

The tile now opens the new Data Encryption Configuration page where you can see the status of all data encryption services, enable and disable each service, and access the page for managing encryption keys.

The new Manage Keys page allows you to see the status and version history of all encryption root keys in your database. You can also perform all steps required to change your root keys safely, including creating a password-protected root key backup.

 

For the detailed blog about this topic, see

For the video tutorial, see

High Availability and Scalability

Secondary Read Access (New)

On the System Replication Overview page, the status for Secondary Read Access is now displayed in the header (when enabled).

Network Security Settings (New)

On the same page, we can view the network configuration settings.

Monitor Network (New)

A new link has been added to the Overview page to the Monitor Network page. On this page, you can measure the network speed between the hosts in a scale-out SAP HANA database with  Measure Network Speed. The result is displayed in the Network Speed Check list, which provides an overview of all network channels between the involved hosts starting with the slowest network connection.

For the detailed blog about this topic, see

For the video tutorial, see

Backup and Recovery

Copying an SAP HANA Database

You can now use SAP HANA cockpit to copy a database, system or tenant, within the same system or to a different system. For this, both file-based backups and backups created with third-party tools can be used.

Backup Encryption (Changed)

Native backup encryption can now be enabled and disabled from SAP HANA cockpit.

For the detailed blog about this topic, see

For the video tutorial, see

SAP HANA Database Explorer

SQL Console Enhancements

The SQL console now displays the name of the connection and also allows you to rename tabs.

Database Object Searching Enhancements

The Object Search now allows you to limit your search to a specific database.

Connection Enhancements

A Connection Status Dialog now appears if you experience network connectivity problems. The dialog allows you to re-establish the connection.

Documentation

For more information, see:

SAP Help Portal

SAP Notes

 

Thank you for watching

The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.

For the full library, see SAP HANA Academy Library – by the SAP HANA Academy

For the full list of blogs, see Blog Posts – by the SAP HANA Academy

 

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Clemens Kopfer
      Clemens Kopfer

      My understanding:
      HANA Cockpit 2.0 is kind of de-coupled from normal HANA, eg release cycles, version numbering etc.

      Do you actually recommend to install a rather small seperate HANA system for that very cockpit, eg virtualized and then monitor all development/testing/production HANA systems/tenants from that very HANA cockpit system? According to my understanding as of now HANA Cockpit 2.0 is not 100% feature complete, but it should be there rather soon.

      Hope my question is not too simple for you 😉

      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Hi Clemens,

      Excellent question. You are right; HANA cockpit is no longer included with HANA.

      In HANA 1.0, it was hosted by the built-in application server XS (classic model). In HANA 2.0, it runs on a separate dedicated system and is hosted by XSA (advanced model).

      In HANA 2.0, the functionality of the single system administration tool (cockpit) and the landscape administration tool (dbcc) have been combined and the new cockpit resembles a bit more SAP Solution Manager in its scope.

      So, yes. Assign a separate system to run cockpit.

      SAP HANA cockpit 2.0 runs SAP HANA, express edition, so the resources required are very modest (compared to a regular HANA system).

      No new development has been done on SAP HANA studio since SPS 12 (May 2016), so although you might find the odd feature that is not yet available in cockpit, most of the functionality should be there or will be added - one may assume - in the upcoming SP 04 (fall) or SP 05 releases.

      Hope this answers your question. Thanks for asking.

       

       

      Author's profile photo Former Member
      Former Member

       

      Hi Denys,

      Thanks for sharing an overview of Cockpit 2.

      Couple of questions here:

      1. Is there a way to register a scale-out system effectively in Resource Manager panel? How to encode scale-out hosts information in import json file.
      2. Which schema holds resource information in cockpit database.

       

      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Hi Muhammed,

      You’re welcome.

      1. The topic is documented in the SAP HANA Administration Guide, Register a Resource:

      https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.02/en-US/ffc4388f212948d6948579e0c1de18d4.html

      Distributed systems are not mentioned separately, I would assume that the node with the master name server should be registered. Are you experiencing any issues?

      There is no built-in functionality yet (to my knowledge) to encrypt the resource export file so any JSON encoder would do.

      Should you want this functionality built-in, there is special site where you can help to improve SAP products: https://www.sap.com/about/customer-involvement/input-beta-testing.html

      2. I don’t know but if I wanted to find out, I would activate SQL trace and run the export command.

      Answers your question?

       

       

       

       

      Author's profile photo Luis Eusa Mendia
      Luis Eusa Mendia

      Hello,

      As we start using the HANA Cockpit 2.0 we find that  users have visual access to all the options on the cockpit, even if they don't have access. So, for example, is a user is not allowed to change users, he will still see the create user option. Eventually if he clicks, he will get permission denied.

      This can be confusing and also, as we need to follow company standards, users without access shouldn't see this options.

      Is there a way of showing users only what they are supposed to see?

      Thanks!

       

      Luis

      Author's profile photo Jose Ramos
      Jose Ramos

      Hi Luis,

      Not at this time, but this item is already in our product backlog and we expect to have a solution in place next year.  We're looking to display only the tiles for the operations that the cockpit user can perform.

      BR,

      José Ramos
      SAP HANA Product Management