cancel
Showing results for 
Search instead for 
Did you mean: 

How to unload a tenant database from memory in HANA?

former_member554948
Participant
0 Kudos

I can unload some tables only from database, but how to unload complete HANA database? Can it be done in HANA Studio, or do I have to do it with a sql script only, or both?

Thanks in advance.

pfefferf
Active Contributor
0 Kudos

What is the intention/goal of that question? Why you wanna unload all tables for a tentant database? Why is it not enough to stop the tenant database if not needed?

former_member554948
Participant
0 Kudos

No I need it, but I have a space problem and just want to free up some space on the disk florian.pfeffer

yakcinar
Active Contributor
0 Kudos

Hello Andranik, Unloading table from memory does not free up space from the disk. Check volume usage instead. If used size of indexserver data file is below 80% of the total size you can use ALTER SYSTEM RECLAIM DATAVOLUME*** to reduce disk usage.

It is also possible that log segments can occupy some space on disk. You can backup logs and use hdbcons "log release" to release freed log segments and free up some more disk.

Accepted Solutions (0)

Answers (0)