Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Job to tract tbale updates

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
GANAPATH

New User


Joined: 06 Mar 2006
Posts: 35

PostPosted: Mon Mar 20, 2006 9:02 pm    Post subject: Job to tract tbale updates
Reply with quote

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
Back to top
View user's profile Send private message

martin9

Active User


Joined: 01 Mar 2006
Posts: 287
Location: Basel, Switzerland

PostPosted: Mon Mar 20, 2006 9:07 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts VSAM multiple updates spoorni JCL & VSAM 2 Wed Dec 30, 2015 10:38 pm
No new posts Sometimes Panel updates doesn't reflect Stefan TSO/ISPF 12 Wed Sep 05, 2012 11:42 am
No new posts RACF group split & mass updates jerryte All Other Mainframe Topics 5 Fri May 27, 2011 2:13 am
No new posts JCL -- Need jcl for mass updates gschandu13 TSO/ISPF 11 Wed Jul 14, 2010 2:37 pm
No new posts Table name and corresponding Updates/... Elixir DB2 3 Tue May 25, 2010 6:08 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us