Reclaim free space datavolume

[former_member60499]

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.

[kaus19d]

Hi,

A small query, did you try after a DB re-org job. Is it a multi-node

Thanks,

Kaushik

[razorlv]

Hello Mostefa Kenida,

We have same issue on 2 of our systems. Did You find solution to run reclaim successfully?

[former_member60499]

Hi,

Find attached, the trace file content generated after reclaim command is issued :

ALTER SYSTEM RECLAIM DATAVOLUME '198-d910-hana-hybris-2:30003' 250 DEFRAGMENT;

The main suspect is this line :

DVolPart::reclaim: Stop marking and moving due to intensive parallel workload, or unfavourable distribution of page sizes

It seems that the shrink operation is stopped for a mysterious reason.

Stofa.

[former_member60499]

Hi,

What do you mean by DB re-org job?

Sorry, i'am at my first steps with SAP HAHA.

Our system is composed by a single node, and a secondo node is in replication whith the following configuration :

Replication mode : sync

Operation mode of SECONDARY: logreplay_readaccess

Thanks.