Learning notes from the learning journey: Installing and Administering SAP HANA to take the Certification “SAP Certified Associate – Database Administrator – SAP HANA”.
- Starting and Stopping SAP HANA:
To start or stop the SAP HANA Database it is possible to split the whole system, stop tenant(s), single instance, or Services.
In the first case, you can use the Cockpit (adm, Cockpit User, Database User) and sapcontrol (root, adm).
In the second case, Cockpit or SQL console or hdbsql (adm, Database user).
The third case, HDB (adm) and SAPControl.
And finally, the services, Cockpit and SQL console or hdbsql.
The SAPControl, you must log on to the SAP System host as a user or as root permissions. Avoid using the SYSTEM user for day-to-day activities.
It’s important to highlight when working with Individual Tenants, the cockpit supports their start/stop, but the studio does not support it.
When dealing with SAP HANA Database Services, it’s possible to stop: Name Server, Preprocessor, Web dispatcher, Compile Server, Index Server, XS Engine. In all the cases, either database services or services of a tenant database are necessary SYSTEM PRIVILEGES.
- Changing Database configuration Parameters:
Display and change parameters are used Database Configuration App in Cockpit. To make changes, is necessary to have System Privileges.
There is a hierarchy of parameters values, which SAP stores in configuration files on the op. System Level:
1) DEFAULT
2) SYSTEM
3) DATABASE
4) HOST