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 , SAP Business Suite on Sybase ASE Database Platform , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.