Hana datavolume reclaim space

[former_member71614]

Hi,

We would like to shrink the data file of index server service in one of the node of a scale out hana system as it is using only 38% of total file size.

Syntax:

alter system reclaim datavolume [space] [<host_port>] <percentage_of_payload_size> <shrink_mode>

Actual Command we are planning to executing:

Instance no: 02

Data file:      Belongs to slave node index server service

Hostname: host14

alter system reclaim datavolume host14:30203 120 defragment

Queries:

1. Hope this can be performed online when,

     Database and application is up and running

     Bw data load jobs are running

     Execution of reports / queries by end users

2. What is the syntax [space] means?

3. Total size of file is 900 GB and used size is 375 GB. If we use percentage_of_payload_size - 120,

    What will be the maximum space can we reclaim?

4. What will be the approximate run time of this alter statement considering the data file size mentioned above?

Regards,

Basis team.

[former_member71614 · Accepted solution]

Hi,

It worked with below command.

alter system reclaim datavolume 'host14:30203' 120 defragment.

We were able to perform this online and roughly took few minutes to 1.30 hour depending on the size of the data file.

Maximum size we had shrunken is from 950 GB to 400 GB.

For safer side, we did this when there is less load in the system.

Note: It took more time to shrink the master node data file.

Hope this will be helpful.

Regards,

Basis team.

[former_member216854]

Hi,

Just wanted to share my experience with running the "ALTER SYSTEM RECLAIM DATAVOLUME 120 DEFRAGMENT" command.

I executed this command on our Pre-Production Scale Up HANA ECC Database which had a indexserver Data Volume file which was 2050GB in size and only ~23% used.

The process ran for 3 Hours 43 Min.  During this time I had our SAP System down to minimize any activity.

In the end, the indexserver Data Volume file was reduce to 485GB.

Hope this information is useful for anyone attempting to run this command.

Thanks.

Matt