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.