Skip to Content
Author's profile photo Denys van Kempen

SAP HANA Cockpit 2.0 SP 04 What’s New – by the SAP HANA Academy

Introduction

Earlier this week (October 31, 2017), the latest support pack for SAP HANA cockpit 2.0 SP 04 was released-to-customer (RTC).

Support pack 04 introduces some nice new functionality to make administering SAP HANA systems easier, more secure, and more manageable for large scale deployments.

With a new home page on the SAP Help Portal and new guides, finding documentation and relevant information about cockpit has also been greatly enhanced.

Below you will find the most important new features listed with reference to the documentation.

 

We have also just started a new playlist on the Academy:

New tutorial videos will be added in the upcoming weeks.

 

For the previous version of this blog, see

For the complete list of the SAP HANA cockpit 2.0 What’s New blogs, see

 

Documentation

SAP HANA Cockpit

As of SAP HANA cockpit SP 04, the latest cockpit documentation is available on SAP Help Portal. This includes the release notes, the Installation and Update Guide, the Administration guide, and education resources, including openSAP and the SAP HANA Academy.

 

Getting Started with SAP HANA cockpit – Documentation and training 

 

SAP Help Portal – SAP HANA Cockpit

 

Administration

Managing Tenant Databases

For tenant management, you can now copy and replicate a tenant database, reset the SYSTEM password and assign the operating system user and group (in case of high isolation level).

For more information, see

 

SAP HANA Cockpit – Manage Databases

 

Tenant-Specific Licenses

As a tenant database administrator, you can now install and delete tenant-specific licenses in your tenant using the Licensing page. Previously, this was only possible using SQL.

For more information, see

 

SAP HANA Cockpit – License

 

Stop System

SP 04 introduces ‘soft’ stops for the SAP HANA system as registered resource with a configurable time (5, 15, 30 minutes). Previously, only immediate stops were avaiable.

SAP HANA Cockpit – Manage Systems

 

Single Sign-on

Single Sign-on (SSO) for registered resources has been available for some time in SAP HANA cockpit 2.0. With SSO enabled (or even enforced) the administrator no longer needs to enter a username and password each time a connection to the database is made.

New in SP 04 is the availability of SSO for the SAP HANA cockpit itself. The administration guide documents how you can configure this using the SAP Cloud Platform (SCP) Identity Authentication service as identity provider (IdP) but if you wish to use another IdP that’s perfectly fine as well, of course.

For more information, see

 

Collecting Diagnosis Information

You can now collect diagnostics from both existing files and the SAP HANA runtime environment using SAP HANA cockpit. This is mainly used for support analysis.

Previously, to collect this information, you had to either use the command line or use tools that are deprecated or on their way out: SAP HANA cockpit for offline administration and SAP HANA studio.

Now that all the functionality of the SAP HANA cockpit for offline administration has been integrated into SAP HANA cockpit 2.0, the link to the offline cockpit is no longer available from the Overview page.

For more information, see

 

 

SAP HANA Cockpit – Diagnosis Files

 

Registering Offline Resources

Previously, the SAP HANA database needed to be up and running (with a valid license) before you could register it as a resource in the SAP HANA cockpit. This is no longer required. You can now register a resource with SAP HANA cockpit even when the cockpit is unable to connect to the resource. Once the resource is registered, you can use the cockpit to start it or update its license.

A newly registered resource that has an invalid or expired license, are offline or stopped, are listed in the Resource Directory with software version 0.00.000.00.0(UNKNOWN) and state Unknown.

For more information, see

 

SAP HANA Cockpit – Resource Directory

 

Cockpit Manager Filtering

You can now filter by type or hostname for Registered Resources and filter by role type for Cockpit Users.

SAP HANA Cockpit Manager – Filter By

 

Scalability

For large-scale cockpit deployments, scalability support has been enhanced. You can now create hundreds of resource groups and cockpit users. Previously, the limit was 100 groups and users.

 

Cockpit API

SAP HANA cockpit now offers REST APIs that you can use with a third-party tool to register resources, create users and groups, and add users and resources to groups.

For more information, see

 

 

User Management and Security Administration

Database User and Role Management

As of SP 04, you can now also assign privileges to users (assigning privileges to roles was added in SP 03). This concludes the studio-cockpit feature parity for database user and role management.

 

SAP HANA Cockpit – Assign Privileges

 

Using the Role page of the SAP HANA cockpit, you can now map LDAP groups to roles If case you are implementing user authorization based on LDAP group membership. Previously, this was only possible using SQL.

SAP HANA Cockpit – Roles

 

The Role page now also shows the role type.

For more information, see

 

Auditing

You can use both the file system and the database as audit trail target but if you selected database tables, you can now delete old audit entries using Auditing page of the SAP HANA cockpit. Typical reason might be that you want to avoid the audit table becoming too large.

For more information, see

 

SAP HANA Cockpit – Auditing

 

Performance Monitoring and Analysis

Collecting Performance Monitor Data

On the Performance Monitor page, you can now import and export collected data.

For more information, see

 

SAP HANA Cockpit – Performance Monitor

 

Memory Analysis

Memory analysis may be required to troubleshoot out-of-memory incidents or to investigate unusual memory usage. As of SP 04, you can now display the details about which allocators are consuming the most memory.

For more information, see

 

SAP HANA Cockpit – Memory Analysis

 

Workload Classes

It is now possible to disable or enable an existing workload class. This will make it easier to test and evaluate the effectiveness of the workload class.

For more information, see

 

SAP HANA Cockpit – Workload Classes

 

Capture and Replay

On the Replay Configuration page in the User Authentication area it is now possible to reset the password for the database users captured in the source system.

Additionally, on the Overview tab, you can now view a comparison of the SQL statements based on results and runtime information. This makes it easier to focus on SQL statements which have a different performance in the execution time, for example, or to identify the reasons why the replay failed.

SAP HANA Cockpit – Replay Configuration

 

Workload Analyzer

SAP HANA cockpit 2.0 SP 04 introduces new functionality for both the Workload Analyzer Based on Thread Samples and for the Workload Analyzer Based on Engine Instrumentation.

On the Thread Samples page, the filters adjustable in the header bar now apply to all charts.

SAP HANA Cockpit – Workload Analysis

 

For Engine Instrumentation (Capture and Replay), on the Capture Information page, you can now view and compare information on a traced workload and also load the trace.

On the Workload Analyzer page, SQL Statements tab, you can now select a particular workload to analyze its Plans and Jobs, and perform a hierarchical analysis of data by adding Request ID to the dimensions.

SAP HANA Cockpit – Capture Information

 

Monitoring System Replication

Finally, three new monitoring features are available for system replication.

The System Replication Overview page, the tables that provide information on the replicating services also display the corresponding tenant database names.

On the Log Shipping Backlog Site 1 to 2 tab, we now get log shipping backlog 24 hours history in a graph displaying different colours should the thresholds set for alert 104 have been surpassed.

On the Replicated Services tab, the replication status tenantcopy is now displayed when a tenant is being copied or moved in the primary system.

For more information, see

 

SAP HANA Database Explorer

There have been several enhancements to both the Catalog Browser and SQL Console for the SAP HANA Database Explorer which will improve the ease-of-use of this tool.

Additionally, the explorer now also has its own guide.

For more information, see

 

 

Catalog Browser Enhancements

Three handy enhancements have been added to the catalog browser of the SAP HANA Database Explorer:

  • The context menu (right-click) now includes connection information (hostname, database)
  • The context menu for catalog objects now includes the option to generate the SELECT statement.
  • When you add filters to the result set of Open Data, a counter now shows the number of active filters.

 

SAP HANA Database Explorer – Connection Information

SAP HANA Database Explorer – Generate SELECT Statement

SAP HANA Database Explorer – Open Data

 

SQL Console Enhancements

Similarly, the Run drop-down menu in the SQL console now contains the Run Statement option (F9) which runs a multi-line SQL statement.

The shortcut key for the Analyze SQL option is now Ctrl-Shift-X.

Should one of the SQL statements in a script (or sequence of statements) return an execution error, you can now choose whether to ignore the error (and continue with the rest of the statements) or abort.

SAP HANA Database Explorer – SQL Console

SAP HANA Database Explorer – SQL Console

 

Documentation

For more information, see:

SAP Community Blogs

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

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.