On our system, the datavolume file for indexserver is about 65GB.
Only 13% ( 9GB) is used.,
When i run the reclaim datavolume command, no free space is reclaimed. The datavolume size remains intact.
-rw------- 1 hdbadm sapsys 65900904448 Jul 24 17:26 datavolume_0000.dat
After running :
ALTER SYSTEM RECLAIM DATAVOLUME SPACE '198-d910-hana-hybris-2:30003' 105 DEFRAGMENT
The file datavolume_0000.dat remains as above.
What is missing and what is wrong in my command and why the free space is not given back?
Below is the details about the datavolume size and the space used as extracted fromm SAP HANA studio :
Total Size (MB): 62.848
Used Size (MB): 8.422
Used/Total Size (%): 13
I expected to see the size reduced to 9GB as i specified 105 in the RECLAIM command.
My SAP HANA version is : 2.00.040