Yes, you can open SQL console and execute the statement −LOAD (, ...);This SQL query will load or unload entire column into or from main memory. Its load status is TRUE or FALSE. The table's load status is PARTIALLY.

In SAP HANA, it is possible to manually load and unload individual tables and table columns.You can perform loading of table to precisely measure the total or “worst case” amount of memory used by a particular table.A table is unload from database to actively free up memory.You can use following SQL queries to perform load/unload of table −LOAD UNLOAD

You can uninstall the license key (LICENSE ADMIN) using one of the following options −In SAP HANA Studio →In the Systems view, right-click the system and choose Properties → Licenses tab On the System License page choose Delete License Key.SQL console −You can also run the SQL command UNSET SYSTEM LICENSE ALL to remove all licenses.

With system privilege LICENSE ADMIN, you can connect to the database and execute license-related queries- obtain previous license data, install a new license key, and delete installed license keys.

A SAP HANA system lockdown in the following scenarios −The temporary license key has expired.When a temporary license key is in use and the hardware key has changed.When permanent license key has expired and it is not renewed within 28 days.When installed license key is an enforced license key and the current memory consumption exceeds the licensed amount plus the tolerance.When all license keys installed in your database are deleted.You can’t run a query in lockdown mode and only a License Administrator can connect to database.

When you move or copy a tenant database, data is replicated from the original tenant database to the new tenant database in the target system. Following tables shows type of data replication for different type of data −Data and logs of the tenant databaseYesTrace and log files   NoData backups    NoConfiguration (*.ini) files with tenant-database-specific values                 NoCertificates and certificate collections stored in the tenant database    Yes                 

When a tenant database is unavailable due to some performance problems, the tenant database administrator can't access diagnosis files. In this case, a system administrator can access the diagnosis files of the tenant database from the system database using the SAP HANA studio.In the SAP HANA studio, open the Administration editor and choose Diagnosis Files and diagnosis files of the system database are displayed.Using the Database filter, select the tenant database → whose diagnosis files you want to see and diagnosis files of the selected tenant database will be displayed.

Yes, it is possible to remove a server component, which are no longer required. This can be performed using ALTER DATABASE SQL command.Following perquisites should be met to perform this task −You are logged on to the system database.You have the system privilege DATABASE ADMIN.To remove a service, you need to open SQL console of the SAP HANA studio and run “ALTER DATABASE” statement.ALTER DATABASE DB1 REMOVE '' AT LOCATION 'HOST_A:30XXX'

Following are the main services that you may need to add to a tenant database:indexserverxsenginescriptserverdpserver

To scale out a tenant database and/or distribute it across multiple hosts, you can add further server components, for example, an additional index server or a separate XS server. You add a service to a tenant database using the ALTER DATABASE SQL command.You do this from the system database using the following command −ALTER DATABASE ADD Following perquisites should be met to perform this task −You are logged on to the system database.You have the system privilege DATABASE ADMIN.