Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
SAP HANA Articles
Page 33 of 58
Removing a service from a tenant database in SAP HANA
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'
Read MoreDiagnosis file of unavailable tenant in SAP HANA database
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.
Read MoreCopying or moving a tenant database in SAP HANA
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
Read MoreLock down of SAP HANA system
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.
Read MoreLoading an individual column in SAP HANA using SQL
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.
Read MoreChanging Ownership of schema in SAP HANA Database
I don’t think you can change ownership of schema in database. Easiest way to change ownership of schema is by exporting a schema, drop it from the database and then recreate the schema owned by the target user and import the objects back into the database.In recent version, you can create schema and set other users as an owner of the schema however you can’t change it later −Create SCHEMA TEST123 owned by Demo;In same way, you can collect the script for "Create procedure" from database and drop the procedures in the earlier user schema and then these can be ...
Read MoreChecking SAP HANA Schema owner name
To check schema owner, you need access on “SYS” schema. Open SAP HANA SQL console and run the following SQL query −SELECT * FROM "SYS"."SCHEMAS";
Read MoreChecking schema creation in SAP HANA database
To check this detail, you should have access on “SYS” schema. Run the following SQL query and it will fetch the following columns −SELECT * FROM "SYS"."SCHEMAS";Schema_NameSchema_OwnerHAS_PRIVILEGESCreate_Time
Read MoreUsing Package specific default schema in SAP HANA
In SAP HANA, you can define package specific default schema as an authoring schema in your schema mapping definition and maintain it in the table M_PACKAGE_DEFAULT_SCHEMA.To perform this, navigate to SAP HANA Modeler perspective →; Maintain Package Specific Default SchemaSelect HANA system and it will show you schema names mapping as per package. You can maintain a default schema for each package. You can also add packages by clicking on Add button.
Read MoreSetting schema mapping in SAP HANA
Schema mapping in SAP HANA is used to move objects from one system to other system i.e. from Development system to Test or Test system to production system.To open schema mapping, navigate to SAP HANA Modeler → Schema Mapping → Select system you want to perform operationIn next window, you have to perform schema mapping between Authoring schema and physical schema.
Read More