Enable & Disable trigger in db2

I am trying to enable and disable trigger in db2.

The command I run : "ALTER TRIGGER CASE_STATUS_CHANGED DISABLE"

And the error is "An unexpected token "DISABLE" was found following "CASE_STATUS_CHANGED". Expected tokens may include: "SECURED".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.18.60"

Can anyone enlight me how to enable and disable the trigger in db2?

Solution

DB2 LUW unfortunately does not allow to disable triggers. You can only DROP a trigger.

There is an ALTER TRIGGER statement. It is the reason for getting that specific error because the statement can be used to switch a trigger from being NOT SECURED to SECURED and back.