2219905 - Logic for counting the unused page is changed for sp_spaceused - SAP ASE

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

sp_spaceused output about unused column  on 157esd#3 upwards is different from previous versions.

•  Previous to 157esd#3  versions
  
  sp_spaceused booksales
  go

name               rowtotal         reserved         data     index_size           unused  
------------------ ---------------- ---------------- -------- -------------------- ------------
 booksales          49                 16 KB             4 KB        0 KB                 12 KB       

create index ind1 on booksales(qty)
go

sp_spaceused booksales
go

name               rowtotal         reserved         data     index_size           unused      
------------------ ---------------- ---------------- -------- -------------------- ------------
booksales          49                 48 KB             4 KB        2 KB                42 KB       

• 15.7 esd#3 upwards versions

sp_spaceused booksales
go

name               rowtotal         reserved         data     index_size           unused      
------------------ ---------------- ---------------- -------- -------------------- ------------
booksales          49                 16 KB             4 KB        0 KB                 10 KB   

create index ind1 on booksales(qty)
go

sp_spaceused booksales
go

name               rowtotal         reserved         data     index_size           unused      
------------------ ---------------- ---------------- -------- -------------------- ------------
booksales          49               48 KB              4 KB          2 KB                    38 KB      

• SAP Adaptive Server Enterprise (ASE) 15.7
• SAP Adaptive Server Enterprise (ASE) 16.0

free space accounting, space , KBA , ase , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement