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.
SAP Knowledge Base Article - Preview