aspose file tools*
The moose likes JDBC and the fly likes Logging trigger activity in log file in db2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Logging trigger activity in log file in db2" Watch "Logging trigger activity in log file in db2" New topic
Author

Logging trigger activity in log file in db2

Pravin Shirke
Ranch Hand

Joined: Apr 05, 2008
Posts: 150

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.


[Vipassana] - It is seeing the reality as it is, And not as you want it to be.!!!
SCJP1.5.
 
jQuery in Action, 2nd edition
 
subject: Logging trigger activity in log file in db2
 
Similar Threads
Logging from a specific thread
Tomcat hangs when app start-up fails
Log file rotation issue in weblogic10
Commit problem
Catalina.out log file