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".

1> use mldtest
2> go
1> sp_dbextend 'list','database','mldtest'

2> 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.