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.