Symptom
- The OTHERS partition on a RANGE partitioned HANA table is being consumed and growing near the 2 billion record threshold limit.
- In this example, the EDID4 table already has 12 ranges existing based on the DOCNUM column with 1.9 billion records outside of the '0000000000000000' -> '0000000044000000' :
SELECT COUNT(*) FROM EDID4 WHERE DOCNUM NOT BETWEEN '0000000000000000' AND '0000000044000000'
1919145089
- How to determine new possible RANGE threshold values for existing records and new range partitions to hold them ?
Read more...
Environment
SAP HANA Platform Edition 2.0
Product
SAP HANA, platform edition all versions
Keywords
KBA , HAN-DB , SAP HANA Database , 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