SAP Knowledge Base Article - Preview

2950474 - DB table growth in SAP HANA related to Packed LOB's

Symptom

  • In SAP HANA Database, there is an issue where disk space is growing.
  • Even after cleanup of table data and reclaim as per SAP KBA 2696420 - How to Manually Reclaim LOB space on Hana, the /hana/data size does not decrease significantly.
  • Result from HANA_Tables_LargestTables* (from note 1969700) on LOB_DISK_GB, shows a large amount of space is taken up by LOB data.
  • Result from HANA_Disks_Data_Overview* (from note 1969700shows a significant portion of the space, is related to Packed LOB data i.e. column PLOB_GB.
  • Table Consistency Check (CHECK_TABLE_CONSISTENCY) against the table returns the following inconsistency:
    ERROR_CODE;ERROR_MESSAGE ;SEVERITY;CHECK_ACTION ;AFFECTED_COUNT;DETAILS
    5,406 ;Lob container with CID= xxx has unusually high overhead, binToRawRatio=5604.99 which is above the threshold of 10 with a total size of 317351264256. Please run REPAIR_HYBRID_LOB_OVERHEAD once on this table.;INFO ;CHECK_HYBRID_LOB_OVERHEAD;? ;?


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 ; SAP NetWeaver 7.5

Keywords

DB growth, reclaim, defragment, MES_DB_AGGREGATE, OPTIMIZE_COMPRESSION, compression,LOBs reclaim , KBA , 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.