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.
The topic of this blog is system administration.
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);
For more information see:
- SAP HANA Cockpit for Offline Administration – SAP HANA Administration Guide – SAP Library
- The Statistics Service – SAP HANA Administration Guide – SAP Library
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