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

SAP Knowledge Base Article - Preview

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

Symptom

  • 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.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) All Versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

dbtable, incorrect structure, syslogs , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.