Skip to Content
0

ALTER SYSTEM RECLAIM DATAVOLUME Statement (System Management)

Nov 25, 2016 at 11:44 AM

51

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers