- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
SAP Developer has Published 85 Articles
SAP Developer
876 Views
In SAP HANA studio, you can start/stop SAP HANA system. In a system with multitenant database containers, all tenant databases will be started except those that were individually stopped. To perform start/stop, right click on HANA system → Configuration and Monitoring → Stop System…
SAP Developer
316 Views
To stop a HANA system, right-click the system you want to stop and choose Configuration and Monitoring → Stop System…Following options are available when you stop a system −Soft − The system is stopped after all running statements have finished or the specified timeout is reached.Hard − The system is ... Read More
SAP Developer
315 Views
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 ... Read More
SAP Developer
777 Views
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 ... Read More
SAP Developer
213 Views
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
SAP Developer
474 Views
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 ... Read More
SAP Developer
254 Views
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 ... Read More
SAP Developer
503 Views
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 ... Read More
SAP Developer
704 Views
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