Diagnosis file of unavailable tenant in SAP HANA database

SAP Developer
Published on 25-Apr-2018 20:20:53
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 ... Read More

Copying or moving a tenant database in SAP HANA

SAP Developer
Published on 25-Apr-2018 20:19:27
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 database               ... Read More

Lock down of SAP HANA system

SAP Developer
Published on 25-Apr-2018 20:18:42
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 ... Read More

Privilege to install a new license key in locked HANA system

SAP Developer
Published on 25-Apr-2018 20:15:54
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.

Uninstalling license key in SAP HANA using Studio

SAP Developer
Published on 25-Apr-2018 20:13:50
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 ... Read More

Load and unload a table in SAP HANA using SQL query

SAP Developer
Published on 25-Apr-2018 20:12:38
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 ... Read More

Loading an individual column in SAP HANA using SQL

SAP Developer
Published on 25-Apr-2018 20:11:39
Yes, you can open SQL console and execute the statement:LOAD <table_name> (<column_name>, ...);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.

Using Switch Ownership option in SAP HANA

SAP ABAP Expert
Published on 25-Apr-2018 20:06:56
With use of switch ownership you can take single or multiple inactive objects from other users. Multiple Information views can be created in HANA system and all these views remains inactive until they are activated in HANA Studio. With use of Switch Ownership option, one user can take ownership of ... Read More

Switch ownership option under SAP HANA Perspective

SAP ABAP Expert
Published on 25-Apr-2018 20:05:42
Switch Ownership option is available under SAP HANA Modeler Perspective. IF you don’t see it under Modeler perspective, try to reset from top.

Difference between take over and Switch ownership in SAP HANA

SAP ABAP Expert
Published on 25-Apr-2018 20:04:38
Below is the difference between take over and switch ownership.Take Over: This option is used to take single inactive object from another workspace.Switch Ownership: This option is used to take single or multiple inactive objects from other users.When you expand Switch ownership option in HANA Modeler, you can see description ... Read More
Advertisements