You execute Reorg with the LONGLOBDATA option to reclaim space for LOB/LONG data, followed by Runstats.
db2 "REORG TABLE SAPSIDDB.BC_BPEM_EL_ENTRY LONGLOBDATA"
DB20000I The REORG command completed successfully.
db2 "RUNSTATS ON TABLE SAPSIDDB.BC_BPEM_EL_ENTRY AND INDEXES ALL"
DB20000I The RUNSTATS command completed successfully.
But afterward notice that no space is reclaimed for the LOB/LONG data.
- IBM DB2 LUW (DB6) any release
Reorg, LONGLOBDATA, LOB, CLOB, BLOB, reclaim space , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this pageThis 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.