1932139 - How to fix the inaccurate free log space accounting reported by sp_helpdb? - SAP ASE

• How to fix the inaccurate free log space accounting reported by sp_helpdb?
• The available free log space is not correctly shown by sp_helpdb. It is larger than the actual log size of the database.

sp_helpdb testdb
go

 name   db_size       owner dbid created      durability lobcomplvl inrowlen
         status            
 ------ ------------- ----- ---- ------------ ---------- ---------- --------
         ------------------ 
 testdb      150.0 MB sa       7 Sep 09, 2013 full                0     NULL
         trunc log on chkpt

(1 row affected)
 device_fragments               size          usage              
         created                   free kbytes      
 ------------------------------ ------------- --------------------
         ------------------------- ---------------- 
 testdb_data                         100.0 MB data only          
         Sep  9 2013  3:58PM                 60280 
 testdb_log                           50.0 MB log only            
         Sep  9 2013  3:58PM       not applicable  
                                                                                                               
 -------------------------------------------------------------------------------------------------------------- 
 log only free kbytes = 100984                                                                                  
(return status = 0)

Here the log free space shows 100984KB, but the actual log size is only 50*1024=51200KB.The log free space exceeds the actual log size.

SAP Adaptive Server Enterprise (ASE) All Versions

dbtable, incorrect structure, syslogs , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To