SAP Knowledge Base Article - Preview

3568134 - HANA Database: Data Storage Reclamation Issue from OTHER_DB

Symptom

  • An issue is encountered with storage space usage and reclamation in SAP S/4HANA.
  • After reducing size of table by deleting old entries, the expected amount of space is not being reclaimed.
  • Specifically, millions of records have been deleted from a table, which initially contained multiple TB of data, but only small portion of space available on disk has been reclaimed.
  • A service is running on the server to validate archived files and based on that validation, files are deleted from the tables. However, the space reclamation is not happening as expected.
  • Database analysis command SQL: "HANA_Disks_Data_Overview" (SAP Note 1969700) shows used space data on disk under the designation 'OTHER_DB' proportionally very high.
  • Data backup takes long time 1-2 days due to size of data persistence.


Read more...

Environment

SAP HANA Database

Product

SAP HANA, platform edition all versions ; SAP S/4HANA all versions

Keywords

SAP HANA, Backup & Recovery, Storage Reclamation, SAP S/4HANA, Space Issue, Database, Snapshot, Backup, Cancel Backup. , KBA , HAN-DB-BAC , SAP HANA Backup & Recovery , HAN-DB-PER , SAP HANA Database Persistence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.