Symptom
The disk size of table BC_MSG is growing rapidly (more than 100GB per day) even though setting the retention to 5 days as per SAP Note 872388.
Running delete job daily but it is not releasing the disk space at DB level.
Checking the monitor view M_TABLE_LOB_STATISTICS for the size of LOB columns in table BC_MSG , it is found that column MSG_BYTES occupied a very large disk space:
For example:
SCHEMA_NAME TABLE_NAME COLUMN_NAME LOB_TYPE DISK_GB BINARY_GB LOB_COUNT
=========== ============= ============================== ======== ========== ========== ==========
SAPJAVA1 BC_MSG DSR_PASSPORT PACKED 0.00 0.00 0
SAPJAVA1 BC_MSG MSG_BYTES PACKED 0.06 0.03 15677
SAPJAVA1 BC_MSG MSG_BYTES FILE 1400.03 1305.52 3906406
SAPJAVA1 BC_MSG PP_HASH PACKED 0.00 0.00 0
SAPJAVA1 BC_MSG TRAN_HEADER PACKED 0.00 0.00 0
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Read more...
Environment
SAP NetWeaver 7.5
SAP HANA DATABASE PLATFORM 2.0
Product
Keywords
BC_MSG, LOB, MSG_BYTES , KBA , HAN-DB-PER , SAP HANA Database Persistence , BC-XI-CON-MSG , Messaging System , 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.