Как говориться, google в помощь

http://www.dbforums.com/showthread.php?1669812-How-to-know-if-a-trigger-is-enable

Hi,
Got the following information from another website. These values are not documented (at least i could not find )
trigger status (enabled/disabled) based on sysstat2 column values for table
sysstat2 & 1048576 (0x100000) != 0 => insert trigger disabled
sysstat2 & 2097152 (0x200000) != 0 => delete trigger disabled
sysstat2 & 4194304 (0x400000) != 0 => update trigger disabled