3166382 - Reclaim database space, overhead parameter on SAP HANA

• You have run the following command on your system: "ALTER SYSTEM RECLAIM DATAVOLUME 120 DEFRAGMENT;"
• It ended within 1 second and no error occurred.
• The defragmentation was successfully but not reclaimed any space back.
• The following example can be observed in indexserver trace file:
  

  [...]

  [0]\{0\}[0/-1] 0000-00-00 00:00:00.000000 i PhysicalPageAcce DataVolumePartitionImpl.cpp(00421) : Reclaim[0, '/hana/data/<SID>/mnt00001/hdb00003.00003/datavolume_0000.dat']:<init>: sizes= (used= 225270mb / max=262464mb | file= 262475mb), curOverhead= 117%, maxOverhead= 120%, moving at least 1024mb per cycle, truncate size 5120mb
  [0]\{0\}[0/-1] 0000-00-00 00:00:00.000000 i PhysicalPageAcce DataVolumePartitionImpl.cpp(00421) : Reclaim[0, '/hana/data/<SID>/mnt00001/hdb00003.00003/datavolume_0000.dat']:<step_finished>: #0: moved 0 pages (0mb) in interval [0mb, 0mb[: sizes= (used= 225270mb / max=262464mb | file= 262475mb (0.0s)
  [0]\{0\}[0/-1] 0000-00-00 00:00:00.000000 i PhysicalPageAcce DataVolumePartitionImpl.cpp(00421) : Reclaim[0, '/hana/data/<SID>/mnt00001/hdb00003.00003/datavolume_0000.dat']:<finished after 1 steps>: moved 0 pages (0mb) in interval [0mb, 0mb[, sizes= (used= 225270mb / max=262464mb | file= 262475mb), curOverhead= 117%, maxOverhead= 120%, 0mb truncated (0.0s)

  [...]

SAP HANA, platform edition 2.0

ALTER SYSTEM RECLAIM DATAVOLUME DEFRAGMENT, RECLAIM, DEFRAGMENT, fragmentation, defragmentation, curOverhead, maxOverhead, overhead , KBA , HAN-DB , SAP HANA Database , How To