In SAP HANA systems, there are two types of administration tasks: those performed at the system level and those performed at the database level.
System Versus Database Administration
Tenant database systems have two levels of administration.
Some administration tasks are performed in the system database and apply globally to the system and all its databases. They include for example:
- Starting and stopping the whole system
- Monitoring the system
- Configuring parameters in configuration (*ini) files at system level
- Setting up and configuring tenant databases, for example:
- Creating and dropping tenant databases
- Disabling features on tenant databases
- Configuring system- and database-specific parameters in configuration (*ini) files
- Scaling out tenant databases by adding services
- Backing up tenant databases
- Recovering tenant databases
- Monitoring the database
- Provisioning database users
- Creating and deleting schemas, tables, and indexes in the database
- Backing up the database
- Configuring database-specific parameters in configuration (*ini) files
Some administration tasks are performed in the tenant database and apply only to that database. They include for example:
you can refer SAP HANA administration guide to get more detailed information about Tenant database administration.
Thanks
Rupesh Chavan