469,353 Members | 2,053 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,353 developers. It's quick & easy.

Monitoring changes in a database

Hello!

I need to monitor a db2 database from a java application. Everytime any
other application changes a table in the database an event should be
fired containing information which table an which dataset has been
changed/inserted/deleted. I am not allowed to use triggers.
Is there anyway to accomplish this? If yes, where can I find a primer?

Many thanks,

Hans

Nov 12 '05 #1
2 1406
If your Db2 database is on windows/unix you can use event monitors.

Hans-Michael Rupp <ha*******@danet.de> wrote in message news:<2m************@uni-berlin.de>...
Hello!

I need to monitor a db2 database from a java application. Everytime any
other application changes a table in the database an event should be
fired containing information which table an which dataset has been
changed/inserted/deleted. I am not allowed to use triggers.
Is there anyway to accomplish this? If yes, where can I find a primer?

Many thanks,

Hans

Nov 12 '05 #2
klh
Hans-Michael Rupp <ha*******@danet.de> wrote in message news:<2m************@uni-berlin.de>...
Hello!

I need to monitor a db2 database from a java application. Everytime any
other application changes a table in the database an event should be
fired containing information which table an which dataset has been
changed/inserted/deleted. I am not allowed to use triggers.
Is there anyway to accomplish this? If yes, where can I find a primer?

Many thanks,

Hans


Hans,

You don't say which version of DB2 you are on, or what platform. Your
options will vary based upon that information. If you are on a
Windows\Unix\Linux platform running DB2 UDB, then you should have
db2audit available to you. It logs all requests hitting the database.
If an sql command comes across that updates 1000 rows you will only
see the sql command itself, not the 1000 changed rows. This may or
may not be what you need.

HTH,
klh
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.