GANAPATH
New User
Joined: 06 Mar 2006 Posts: 35
|
|
|
|
Hi,
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.
Thanks,
ganapth |
|
martin9
Active User
Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
|
|
|
|
hy ganapath,
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.
martin9 |
|