SAP Knowledge Base Article - Preview

3268402 - sp_dbextend raises a 7452 error and shows incorrect status "disabled by LCT" - SAP ASE

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

SAP Adaptive Server Enterprise 16.0

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.