I have created set of tables with data in it. I would like a have a job(JCL) that i can run against these tables every day in the night to see what tables have been updated and what are the changed rows, can anyone suggest me.
Joined: 01 Mar 2006 Posts: 287 Location: Basel, Switzerland
you can do this with the DB2 Log Analysis Tool,
but normally this is not included in the db2 package,
and the license is much to high.
therefore use on your tables a field (attribute),
which contains a timestamp. therefore
you can query each day if there had been any updates.