SAP Knowledge Base Article - Preview

2847731 - Automatic database space expansion stop working after few space expansions - SAP ASE

Symptom

  • Automatic database expension is enable using sp_dbextend for logsegment.
  • The expansion work after few times of expension.
  • User transaction become log suspend due to the transaction is full
  • In the user database, sp_dbextend "list","threshold" report the following message and the log segment free space is lower than the last chance threshold with status "disabled by LCT" or empty

    Failed to find specified threshold in threshold cache on instance 1 for database TESTDB (20), segment 2, free space 322560. Use 'dbcc thresholds' to see the threshold cache contents.
    segment name free pages free pages (KB) threshold procedure status
    -------------- ------------ ----------------- --------------------- ---------------

    logsegment 545184 2180736 sp_thresholdaction last-chance
    logsegment 5376000 21504000 sp_dbxt_extend_db disabled by LCT
    Log segment free space currently is 1216204 logical pages (4864816K).


Read more...

Environment

SAP Adaptive Server Enterprise 15.7
SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

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