Triggers not always executing.

[GKern@xxxxxxxxxxxxxxxx]

Does anyone know of any type of DB commands/utilities that could be used 
to diagnose trigger processing?

I have a situation where record updates should trigger a program to 
execute but for some reason the trigger doesn't always execute. Almost all 
of the time (99.9%) of the time the trigger appears to work. 

I wrote the trigger program, and included code in it to log triggered 
update requests to a logfile. Other than logging the trigger requests, is 
there anything else I can do to monitor the triggers?

Regards,

Gerald Kern
IBM Certified AS/400 RPG IV Developer & RPG IV Programmer
MIS Project Leader, Lotus Notes/Domino Administrator
The Toledo Clinic, Inc.
4235 Secor Road
Toledo, OH 43623-4299
Phone 419-479-5535
gkern@xxxxxxxxxxxxxxxx