SAP HANA Admin - Key Commands

Display the general information about HANA database and has to be executed in the command line

hdbsql -n localhost -i 1 -u username -p Password \s 

This command will display the details of HANA database such as the host name, database, user, Kernel version, SQLDBC version, etc.

View the concurrent database login to HANA database

hdbsql -n localhost -i 1 -u username -p Password 
"SELECT CNO,TITLE,FIRSTNAME,NAME,ZIP FROM Database_Name" 

The above command displays the following result about concurrent sessions −

CNO | TITLE | FIRSTNAME | NAME | ZIP 

Start and stop HANA database from HDB

To start and stop HANA database using HDB, you have to login to HANA system host as <sid>adm and run the following command −

/usr/sap/<SID>/HDB<instance number>/HDB start 
/usr/sap/<SID>/HDB<instance number>/HDB stop