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.