SAP Knowledge Base Article - Preview

2904626 - alter table <table> disable/enable trigg on a bound table not behaving as expected - SAP ASE

Symptom

In ASE 16.0 and in the documentation - if an object bound using dbcc trune(des_bind, dbid, object) -- altering a trigger should give an error:

Msg 8242, Level 16, State 1:
Server 'myserver', Line 2:

The table 'z1' in database 'mydb1' is bound to metadata cache memory. Unbind the table and retry the query later.

However, in ASE 15.7 - this process works with no errors given:

dbcc tune(des_bind, 4, a1)
go
alter table a1 disable trigger
go
Warning: trigger 'SYB_DELETE' is already disabled.

alter table a1 enable trigger
go
Enabling trigger 'SYB_DELETE'.

Enabling or disabling a trigger, does not cause the expected message.  


Read more...

Environment

SAP Adaptive Server Enterprise 15.7

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

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.