Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
dvankempen
Product and Topic Expert
Product and Topic Expert

Introduction

In the upcoming weeks we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA Support Package Stack (SPS) 11.

What's New with SAP HANA SPS 11 - by the SAP HANA Academy

The topic of this blog is system administration.

What's New?

SAP HANA Cockpit for Offline Administration

The SAP HANA cockpit for offline administration is a tool with the same Fiori look and feel as the SAP HANA cockpit (to keep it simple), and the same functionality as the SAP HANA administration console in diagnostic mode (cloud-enablement).

The regular SAP HANA cockpit is a web application that is powered by SAP HANA, which also means that when HANA is powered off, the web app is not available. The tool SAP HANA cockpit for offline administration fills up this hiatus as it is hosted by the SAP host agent, just like the tool for platform lifecycle management: HDBLCM on port 1228 for HTTP and 1229 for HTTPS.

You can use the SAP HANA cockpit for offline administration to:

  • start, stop, or restart a SAP HANA system
  • view or download log and trace files generated by the different SAP HANA processes (indexserver, daemon, xsengine, etc.), and to collect diagnostic information and/or runtime environment (RTE) dump files
  • troubleshoot an unresponsive system by analysing connections, transactions and or threads, with the option to cancel (all) transactions

You connect to the tool using operating system credentials of the <SID>adm user. For this reason, SAP strongly recommends to use HTTPS and replace the self-signed certificate with a properly signed one.

Statistics Server Data Management

To avoid that the tables that store statistics and alerts data in the _SYS_STATISTICS schema grow to manageable sizes, we can now perform data management operations on these tables using SQL.

Additionally default limits have been set to the tables: 42 days max for collectors and 1.000.000 rows for alerts.


UPDATE _SYS_STATISTICS.STATISTICS_SCHEDULE
SET RETENTION_DAYS_CURRENT = 42 -- Enter here the retention period in days
WHERE ID = 8; -- enter here the collector identifier
SELECT *
FROM _SYS_STATISTICS.STATISTICS_OBJECTS
WHERE type = 'Collector';


INSERT INTO _SYS_STATISTICS.STATISTICS_PROPERTIES
VALUES ('internal.alerts.maxrows', 500000);

Tutorial Video

SAP HANA Academy - SAP HANA SPS 11: What's New? - System Administration - YouTube

Documentation

For more information see:

Thank you for watching

You can view more free online videos and hands-on use cases to help you answer the What, How and Why questions about SAP HANA and the SAP HANA Cloud Platform on the SAP HANA Academy at youtube.com/saphanaacademy.

Follow us on Twitter @saphanaacademy

Connect with us on http://linkedin.com/in/saphanaacademy