- SAP Managed Tags:
Introduction
In the upcoming days and weeks, we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA cockpit 2.0 SP 07, released August 7, 2018.
For the previous version of this What's New blog, see
- SAP HANA Cockpit 2.0 SP 06 What’s New – by the SAP HANA Academy
For the complete list of the SAP HANA cockpit 2.0 What's New blogs, see
- What’s New - SAP HANA cockpit 2.0 – by the SAP HANA Academy
For the Getting Started with SAP HANA cockpit 2.0 blog, see
- Getting Started with SAP HANA Cockpit 2.0 – by the SAP HANA Academy
YouTube Playlist
For the full SAP HANA cockpit playlist on YouTube, see
Documentation
New features and known issues are documented in
- SAP HANA Cockpit SP 07 Features – What's New in the SAP HANA Cockpit 2.0
- 2628614 - SAP HANA Cockpit 2.0 SP 07 - SAP Note
For all SAP HANA cockpit documentation, see
- SAP HANA Cockpit - SAP Help Portal
Installation and Update
Install the SAP HANA Cockpit in an Existing SAP HANA System
As of SP 07, a dedicated SAP HANA system for the SAP HANA cockpit is no longer required.
You can now install cockpit in an existing SAP HANA system (shared database).
As with the Shared Hardware deployment option, the benefit is that you can leverage existing infrastructure. The difference is that even less hardware resources are required (less overhead) at the cost of less control: cockpit is not available when the system is down. Most suitable candidates are single system environments, in particular those used for training and development.
 |  |
Tutorial Video - Shared Database Installation
https://youtu.be/_2ztLZxEVeo
According to SAP Note 2628614 - SAP HANA Cockpit 2.0 SP 07: If you’re installing the cockpit’s persistency on an existing SAP HANA 2.0 system, you will be prompted to enter the XS Advanced Admin user. Enter the user as COCKPIT_ADMIN, rather than the default of XSA_ADMIN.
Tutorial Video - Resource Registration
https://www.youtube.com/watch?v=jE1WHdWNQwA
Tutorial Video - Update
https://www.youtube.com/watch?v=YMWwH4dVnmE
Tutorial Video - Installation
https://www.youtube.com/watch?v=HDOGojJoH1A
Software Downloads
You can download SAP HANA cockpit 2.0 SP07 (with latest patches) from the SAP ONE Support Portal, section Downloads (URL: https://support.sap.com/swdc).
Extract the archive using the sapcar utility.
Update or install a new SAP HANA cockpit system using SAP HANA Lifecycle Management in graphical mode (hdblcmgui.sh) or command line (hdblcm.sh).
For the documentation, see
Administration and Monitoring
Video Tutorial
https://youtu.be/oOKQTadJnvU
User Interface
One of the biggest changes for this release is the redesigned of the user interface using SAP Fiori Design Guidelines. You can now
- Move, add or hide tiles
- Filter tiles by area
- Save frequently used resources as tiles to appear in the Landscape page
This allows for more efficient use of screen space showing rich and dynamic content , personalization, and reinforces SAP's continuous goal to improve the user interface and experience (UI/UX).
System Overview
Monitor Landscape
For the documentation, see
Aggregate Health in Resource Directory
Video Tutorial
https://youtu.be/bys1MbYito8
The Aggregate Health Monitor has been added to the Resource Directory and is no longer available as a separate page/app.
For the documentation, see
Early Watch Alerts
Video Tutorial
https://youtu.be/x-aahVgdVDk
Cockpit users with S-User authorization can now select the Early Watch Alert tile to launch the SAP EarlyWatch Alert (EWA) Solution Finder in the SAP ONE Support Launchpad.
For the documentation, see
For a comprehesive overview about how to configure system monitoring, see the SCN Community Wiki resource
User Notifications and Session Monitoring
Video Tutorial
https://youtu.be/aiOp3-YTiFQ
Administrators can now monitor browser sessions and send pop-up notifications to logged-in cockpit users.
For the documentation, see
Configuration Templates
Video Tutorial
https://youtu.be/NTOqughMarg
With Configuration Templates you can create named sets of configuration parameters and apply them to your databases. Any cockpit user can apply templates but to create and change templates, you need the Cockpit Template Administrator role (new).
For the documentation, see
Managing Restricted Features
Video Tutorial
https://youtu.be/ZATaUoffA-w
The Manage Restricted Features page has been enhanced and you can now also copy restricted features.
For the documentation, see
Table Distribution
Enhancements have been made to Table Distribution and Redistribution History. For example, when generating a Table Redistribution Plan, you can now use the Plan Steps and Analysis tabs before deciding to execute the plan.
For the documentation, see
Workload Classes
Enhancements have been made to the user interface for the Workload Classes (more intuitive).
For the documentation, see
Licensing
Memory usage of your SAP HANA license is now visualized on a chart.
Cockpit APIs
You can now manage resources, users, and groups with cockpit APIs.
Video Tutorial part 1 (GET)
https://www.youtube.com/watch?v=wuy8eTRU_EE
Video Tutorial part 2 (POST)
https://youtu.be/zj5qnJeR8Z0
For the documentation, see
Backup and Recovery
Full backups (complete data backups or data snapshots) and backup generations (full backups plus delta, log and catalog backups) can now be deleted manually.
https://youtu.be/omjhhKffCwE
Additionally, you can configure settings for the retention of backup generations (SPS 03 or later).
For the documentation, see
User Management and Security Administration
User Groups
You can create user groups in SAP HANA cockpit and configure group-specific password policies. Previously, this was only possible using SQL.
For the documentation, see
LDAP User Authentication
You can now configure users for LDAP authentication. Previously, this was only possible using SQL.
For the documentation, see
Auditing
You can now generate the SQL create statements of multiple audit policies.
For the documentation, see
SAP HANA Database Explorer
Video Tutorial
https://youtu.be/WXr5RaLfB60
Remote Sources
The remote source editor has been updated to improve search performance and support remote sources for SAP HANA smart data integration.
For the documentation, see
Catalog Enhancements
To support SAP HANA smart data integration, the catalog browser now shows Data Provisioning Agents and Remote Sources (Remote Subscriptions and Tasks).
SQL Debugger
The SQL Debugger functionality from the SAP Web IDE for SAP HANA has been added to the SAP HANA Database Explorer.
Importing Data
There is a new Import Data dialog to import Excel or CSV data. File size is limited to 40 MB for XLS(X) and 200 MB for CSV.
For the documentation, see
For the documentation, see
Performance Monitoring and Analysis
Capture and Replay
The Replay Monitor page (section Target System Information) and the Replay Report (section Replay Information) now displays the request rate.
On the Comparison Report (Performance Comparison), you can now change the tolerance ratio.
On the Replay Configuration page (Target System Information section), you can now enter the port number.
On the Overview page of Result Comparison and Performance Comparison, you can now see new categories such as SQL Errors, Non-SQL Errors, and Verification Skipped.
On the Capture Configuration page, you can now use the New Backup Settings link to select between Backint or file-based backups, to configure the backup destination, or to enter parameters for the Backint backup.
For the documentation, see
SQL Analyzer
You can now save SQL plans to the SAP HANA database, load previously saved plans into the SQL analyzer, and download saved SQL plans as PLV files to your computer.
The Overview tab of the SQL analyzer is enhanced by graphic views of the SQL time, dominant operators, and statistics.
You can navigate to the Operators section below by selecting Open Operators and see the Tables in Use section below by clicking on the Tables in Use field in the Statistics tile.
The Table Accesses section is now enhanced by the following columns that can be added in the settings menu: Operator Id, Operator Name, Details.
For the documentation, see
Workload Analyzer
Thread Sampling
Background Jobs and Timeline are now in separate categories and you can navigate to the SQL analyzer by selecting an entry on the chart in the Top SQL Statements section and clicking Open in SQL Analyzer.
Engine Instrumentation
You can access the analyzer from the Capture Management page of the capture and replay tool. The Timeline view displays a detailed timeline chart and an accompanying statements table.
For the documentation, see
References
For more information, see:
SAP Community Blogs
- What’s New with SAP HANA cockpit 2.0 - by the SAP HANA Academy
- Getting Started with SAP HANA Cockpit 2.0 - by the SAP HANA Academy
SAP Help Portal
SAP Notes
- 2628614 - SAP HANA Cockpit 2.0 SP 07
- 2380291 - SAP HANA 2.0 Cockpit Central Release Note
- 2373065 - SAP HANA 2.0 Database Explorer Release 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
- Subscribe to our YouTube channel for updates
- Join us on LinkedIn linkedin.com/in/saphanaacademy
- Follow us on Twitter @saphanaacademy
- Google+ plus.google.com/+saphanaacademy
- Facebook facebook.com/saphanaacademy
2 Comments
