• Post Reply Bookmark Topic Watch Topic
  • New Topic

Logging trigger activity in log file in db2

 
Pravin Shirke
Ranch Hand
Posts: 152
Chrome Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ranchers,

Our production server is AIX and our db is DB2 and our Application server is WAS(Websphere application server).In our application their are couple of triggers on production servers which gets executed most of the times. but sometimes the trigger fails and because of which their is inconsistency in the tables. Also we are not able to find any exception or error message in the application log. So my question is can we monitor the trigger activity or log the trigger failure in the logs.
we dont want to create another trigger for logging the trigger activity in the logs. Also, we dont want to modify our triggers.

Please help i am stuck here . any pointers on how to proceed further will be appreciated.

Thanks & Regards.
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!