SAP Knowledge Base Article - Preview

2562939 - HANA Data Volume Used Size is Doubled or Much Larger than Before

Symptom

  • Data volume used size is doubled or much larger than before 
  • Disk size of tables in total shown in result of "SQL HANA_Memory_Overview" (attached in SAP Note 1969700) is much smaller than the data volume used size
  • There are old snapshots shown in result of "HANA_IO_Snapshots" (SNAPSHOT_TYPE = '%', MIN_SNAPSHOT_AGE_H = 5)  (attached in SAP Note 1969700)
  • There is no large tabled imported or index created 
  • "ALTER SYSTEM RECLAIM DATAVOLUME" could not reclaim data volume used size


Read more...

Environment

  • SAP HANA, platform edition 1.0
  • SAP HANA, platform edition 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

datavolume_0000.dat, disk full event, hdbcons, significantly increased disk space requirements, largest table, growing, datashipping_snapshot_max_retention_time, system replication, FOR_BACKUP, true, false , KBA , HAN-DB-PER , SAP HANA Database Persistence , HAN-DB-BAC , SAP HANA Backup & Recovery , HAN-DB-HA , SAP HANA High Availability (System Replication, DR, etc.) , How To

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.