471,886 Members | 1,144 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,886 software developers and data experts.

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 1449
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.

Similar topics

reply views Thread by Jeff Reed | last post: by
5 posts views Thread by Joe | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.