LLI Wiki — My Digital Knowledge Base

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
Mastodon LLIMastodon SocialFosstodon