Not in general.
What you can do is fire the trigger given a specific condition in the
trigger when-clause.
One example may be to have s special SESSION_USER that is exempt from
triggers.
So, by taking on that user a session can be exempted.

Cheers
Serge

"vijaykumar " <db2udbdba-ezmlmshield-x62520548.[Email address protected]
wrote on 04/25/2006 12:29:25 AM:

> is it possible to enable and disable a database trigger in DB2
>
> vijaykumar.g
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


DB2 & UDB email list listserv db2-l LazyDBA home page