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 1969700) shows 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,REPAIR_HYBRID_LOB_OVERHEAD , 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.
SAP Knowledge Base Article - Preview