Skip to Content

Reclaim free space datavolume

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jul 25, 2019 at 07:44 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 25, 2019 at 10:10 AM

    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.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.