473,224 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 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 1516
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Jeff Reed | last post by:
I am experiencing the the problem outlined the below. Unfortunately, I am using WinXP and I not sure if I can apply the solution due to lack of security control Any feed back would be apreciated ...
1
by: Edward Yang | last post by:
I setup web.config with impersonation="true". On our local server the project works great. I did the same procedures on our staging server, but it failed with an impossible error: Server Error in...
2
by: Greg Allen | last post by:
I know this has been discussed before, and have found some documentation about it on the web. But nothing has fixed my problem. I am running the 1.1 .NET framework, SP1. I have a web...
9
by: Tim D | last post by:
Hi, I originally posted this as a reply to a rather old thread in dotnet.framework.general and didn't get any response. I thought it might be more relevant here; anyone got any ideas? My...
5
by: Joe | last post by:
I'm getting the following error when trying to call a page on a secure server. I'm not doing any impersonations or file access of any kind. The page is using PayPal and I'm wondering if PayPal has...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.