chriselswede / hanacleaner

A house keeping script for SAP HANA
76 stars 44 forks source link

Desired behaviour or bug? RECLAIM DATAVOLUME / -fl #40

Open spiezmaestro opened 1 year ago

spiezmaestro commented 1 year ago

Hi,

The parameter -fl is described as:

-fl fragmentation limit [%], maximum fragmentation of data volume files, of any service, before defragmentation of that service is started: ALTER SYSTEM RECLAIM DATAVOLUME ':' 120 DEFRAGMENT, default: -1 (not used) Note: If you use System Replication see Q19 in SAP Note 1999880.

This means, that when parameter -fl is set to e.g. 110, the check is made if a reclaim needs to be done (defrag > 110%) and when so, a reclaim datavolume 120 defragment is executed.

Should this not be a reclaim datavolume 110? What purpose could the check for a specific value have, when always a reclaim datavolume 120 is executed anyway?

Therefore the question, desired behaviour (in which case we will need to change the hardcoded 120 with our desired value) or a bug?

Thanks a lot!

Cheers.