I'm developing a VB.NET application that is going to be checking if a table has been changed and if it has get the data and send it off to another application.
I was looking into ways for an application to know that there has been new data added to the database (Insert/update) or removed from the database (delete). There are only two methods that I found the first is querying the database constantly but this isn't very scalable and would probably take down our sever. The second approach is via a Query Notification but it seems that this is only do able with SQL Server 2005 and we use DB2 here.
My question is what is an efficient scalable method of checking for new data in a database that can be implemented using a DB2 database and VB.NET?