Skip to Content
2
Jul 24, 2019 at 03:37 PM

Reclaim free space datavolume

640 Views

Hi There,

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.

Before :

-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 :

Name: datavolume_0000.dat

Type: DATA

Total Size (MB): 62.848

Used Size (MB): 8.422

Used/Total Size (%): 13

Path: /hana/data/HDB/mnt00001/hdb00003.00003/

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

Thanks

Stofa.