SAP Knowledge Base Article - Preview

2281606 - sp_spaceused values for partitioned tables explained - SAP ASE

Symptom

  • When running sp_spaceused, outputs show high value for 'unused' space.
  • Value does not reduce to a much lower or near zero value after a REORG REBUILD.
  • Sample outputs look like :

BEFORE REORG REBUILD
name        rowtotal   reserved       data        index_size   unused
----------- ---------  -------------  ----------  ------------ ------------
tab_name    1002221    2590032 KB     57744 KB    298848 KB    2026608 KB



REORG REBUILD of table 'tab_name' completed.
name        rowtotal   reserved       data        index_size   unused
----------- ---------  -------------  ----------  ------------ ------------
tab_name    1002221    1705216 KB     58416 KB    286480 KB    1253488 KB


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0
  • SAP Solution Manager (SOLMAN) 7.1

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager 7.1

Keywords

unused , reserved , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , How To

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.