Skip to Content
avatar image
Former Member

ALTER SYSTEM RECLAIM DATAVOLUME Statement (System Management)

Hi all, I have a question to the following statement: ALTER SYSTEM RECLAIM DATAVOLUME

If I reorganize the Row store, there is a note 1813245 with a quite good procedure to calculate in advance the amount possible free space in sparse segments.

I found also a note 2014987, how I have to handle column store tables.

And also a blog who describe some things about storage reorganisation:

https://blogs.sap.com/2013/05/27/andy-silvey-sap-hana-command-line-tools-and-sql-reference-examples-for-netweaver-basis-administrators/#jive_content_id_58b_How_to_Handle_Empty_Column_Store_Tables_have_large_size_on_disk


What I need now is for ALTER SYSTEM RECLAIM DATAVOLUME a similar procedure like deliverd by SAP for the Row store optimization.


How can I calculate the amount of free space in advance, will be won by the RECLAIM DATAVOLUME.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers