Category - HANA

In this article I show You shortly how to install administration tool SAP Hana Cockpit. Next week will second part about configure and granting permissions to users.

SAP HANA cockpit provides a single point of access to a range of tools for administration and detailed monitoring of multiple, individual and tenant SAP HANA databases, and also integrates the SQL development capabilities required by administrators.

I try shortly show You how can You use HANAClenaer script to perform regular cleanup activities – both manually and from the scheduler.

You have configured in Your HANA “E-mail Notification for Alerts”. How to do this You can find here. Although You correctly receive e-mail notifications in the indexserver logs, You can find information such as:

When You administrate SAP HANA, You often wonder about questions:
1. How can I reduce size datavolume?
Probably You deleted old: logs, traces and backups. You also RECLAIM DATAVOLUME. What else??

2. If You look at screens below, You see that:

• One of them show that one datavolume use 96% of total size.
• You wonder what’s happen if the total size will be have 100%?
• Maybe You think HANA automatically will be use other datavolume (number 00002 or 00004)??

From time to time You check the size of the tables in HANA using e.g. a script: SQL:”HANA_Tables_LargestTables” from SAP note 1969700 SQL Statement Collection for SAP HANA. In the column LOB_DISK_GB, You observe a large amount of space is taken up by LOB data: