SAP HANA: quick checks with hdbsql and sapcontrol
Common commands to list tenants, sapinit services and the status of SAP instances with hdbsql and sapcontrol.
A few commands to get a quick view of an SAP HANA system from the OS and from SQL.
From SQL
List the tenant databases:
select * from "SYS"."M_DATABASES"
Services and instance status
Check the SAP start service:
sudo systemctl status sapinit
The registered instances are listed in /usr/sap/sapservices:
more /usr/sap/sapservices
Process list and instance list through sapcontrol (replace 10 with your instance number), and the HANA process overview:
sapcontrol -nr 10 -function GetProcessList
sapcontrol -nr 10 -function GetSystemInstanceList
HDB info