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

If your Db2 database is on windows/unix you can use event monitors.

Hans-Michael Rupp <hans.rupp@danet.de> wrote in message news:<2m9ps8Fkg66tU1@uni-berlin.de>...[color=blue]
> 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[/color]

Hans-Michael Rupp <hans.rupp@danet.de> wrote in message news:<2m9ps8Fkg66tU1@uni-berlin.de>...[color=blue]
> 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[/color]

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