- SAP HANA Admin Tutorial
- SAP HANA Admin - Home
- SAP HANA Admin - Overview
- Architecture Overview
- Multitenant Database
- Multiple Host Systems
- Tools
- Cockpit
- Studio
- SAP HANA Admin - System Mngmt
- Multitenant DB Container Mgmt
- Starting a HANA System
- Stopping a HANA System
- License Keys
- Monitoring the HANA System
- SAP HANA Admin - Table Mngmt
- SAP HANA Admin - Table Partition
- SAP HANA Admin - Table Replication
- Data Compression
- Solman Integration
- SAP HANA Admin - Lifecycle Mngmt
- Securing HANA System
- User Provisioning
- Authentication Methods
- Auditing Activities
- Backing Up HANA System
- Recovery HANA System
- HANA XS Application Service
- Data Provisioning
- Smart Data Access
- New Remote System Connection
- Integration with Hadoop
- Key Commands
- Job Responsibilities
- SAP HANA Admin Useful Resources
- SAP HANA Admin - Quick Guide
- SAP HANA Admin - Useful Resources
- SAP HANA Admin - Discussion
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
Advertisements