Symptom
In an MLD (Mixed Log and Data) database, after the LCT (last-chance threshold) is recalculated by data change, sp_dbextend raises a 7452 error and shows incorrect status "disabled by LCT".
use mldtest
go
sp_dbextend 'list','database','mldtest'
go
name segment item value status
----------- ------------- --------- -------- ----------
server-wide (n/a) (n/a) (n/a) enabled
default (all) growby 10% enabled
Failed to find specified threshold in threshold cache on instance 1 for database mldtest (7), segment 2, free space 16. Use 'dbcc thresholds' to see the threshold cache contents.
segment name free pages free pages (KB) threshold procedure status
-------------------- --------------- -------------------- --------------------------- ------------------------
logsegment 520 1040 sp_thresholdaction disabled by LCT
Log segment free space currently is 17030 logical pages (34060K).
(return status = 0)
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error
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