SAP Knowledge Base Article - Preview

3459041 - The 'log only free kbytes' shows a very high/unreasonable value after migrate the database with 'hole' - SAP ASE

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.