Symptom
- Can not allocate log segment to any process, have to extend the log segment
- Can not truncate the log segment
- The ' log only free kbytes' shows a very high value/unreasonable value, like:-
1> sp_helpdb eb_<dbname>
2> go
name db_size owner dbid created durability lobcomplvl inrowlen status
------------------- ------------- ----- ---- ------------ ---------- ---------- -------- ------------------------------------------------------------------------
<dbname> 31332.0 MB sa 11 Feb 17, 2024 full 0 NULL select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full
....
--------------------------------------------------------------------------------------------------------------
log only free kbytes = 68661858960, log only unavailable kbytes = 62349312, data only unavailable kbytes = 548
(return status = 0)
Read more...
Environment
SAP Adaptive Server Enterprise 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
migration, dump/load, log segment, log only free kbytes , log , free ,space, big, large, huge, unacceptable, hole , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.