Many a time, we need to check the status of the tenant DB. As you all must be aware of the common techniques using SAP HANA Studio and SAP HANA Cockpit. I would like to explain a few more techniques for the same.
You can use the HDBSQL command SELECT * FROM M_DATABASES; to check the status of Tenant DB. This command should be executed on System DB. ‘ACTIVE_STATUS’ column will signify the status of Tenant DB. Here it is YES means Tenant DB is up and running.
SAPCONTROL and HDB info are the command line utilities to check the status. In HDB info, you will find process with name hdbindexserver -port XXXXX whereas the SAPCONTROL will give you output like below.
SAP HANA Database Tips 
Usefull for beginners
LikeLiked by 1 person
Thanks Shivani
LikeLike
Hi
when I run query select * from M_VOLUME_FILES in systemdb , I cannot get tenant database info , is there another view to see tenant database files from SystemDB
Thanks
LikeLike
Run it from Tenant DB for information related to Tenant DB.
LikeLike