SAP Knowledge Base Article - Preview

3239715 - Reorg does not reclaim space for LOB/LONG data

Symptom

You execute Reorg with the LONGLOBDATA option to reclaim space for LOB/LONG data, followed by Runstats.

example:
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.


Read more...

Environment

  • IBM DB2 LUW (DB6) any release

Product

SAP NetWeaver 7.5

Keywords

Reorg, LONGLOBDATA, LOB, CLOB, BLOB, reclaim space , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.