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