Unix/Linux Go Back    


Programming Post questions about C, C++, Java, SQL, and other programming languages here.

DB2 - Tracking Table history

Programming


Reply    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 12-18-2017   -   Original Discussion by Perlbaby
Perlbaby's Unix or Linux Image
Perlbaby Perlbaby is offline
Registered User
 
Join Date: Oct 2011
Last Activity: 3 May 2018, 7:51 AM EDT
Posts: 66
Thanks: 9
Thanked 0 Times in 0 Posts
DB2 - Tracking Table history

HI team

Is it possible to track DB2 table on the data insertion,deletion and updates on daily basis . Do we have any inbuilt feature to handle audit analysis ?

Any help appreciated
Sponsored Links
    #2  
Old Unix and Linux 12-18-2017   -   Original Discussion by Perlbaby
rbatte1's Unix or Linux Image
rbatte1 rbatte1 is offline Forum Staff  
Root armed
 
Join Date: Jun 2007
Last Activity: 18 May 2018, 7:30 AM EDT
Location: Lancashire, UK
Posts: 3,533
Thanks: 1,553
Thanked 692 Times in 622 Posts
In Oracle, this would be best done with a trigger. This fires on the conditions you set and can write an audit trail, however you have to be careful about the impact of enabling them because IO can be hit quite badly (capacity and performance)

There is a similar facility for DB2. Try an internet search for "DB2 trigger" and see if that helps.

From there it should just be a simple report to run as required to get the information based on what you saved.



Robin
Sponsored Links
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Tracking users through history command punpun66 Shell Programming and Scripting 1 03-26-2014 12:40 AM
Tracking All session history in one file monojcool Red Hat 0 02-21-2013 12:36 AM
select values from db1 table and insert into table of DB2 aemunathan Shell Programming and Scripting 2 02-10-2010 10:35 PM
Connect to DB2 table using Shell scripts onlyraja Shell Programming and Scripting 1 01-15-2010 05:06 AM
How to connect DB2 table using shell script dtidke Shell Programming and Scripting 0 06-24-2008 05:18 AM



All times are GMT -4. The time now is 01:04 AM.