Unix/Linux Go Back    

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

DB2 - Tracking Table history


Thread Tools Search this Thread Display Modes
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: 27 December 2017, 6:32 AM EST
Posts: 62
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
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: 23 January 2018, 6:47 AM EST
Location: Lancashire, UK
Posts: 3,445
Thanks: 1,494
Thanked 673 Times in 606 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.

Sponsored Links

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 01:40 AM
Tracking All session history in one file monojcool Red Hat 0 02-21-2013 01:36 AM
select values from db1 table and insert into table of DB2 aemunathan Shell Programming and Scripting 2 02-10-2010 11:35 PM
Connect to DB2 table using Shell scripts onlyraja Shell Programming and Scripting 1 01-15-2010 06:06 AM
How to connect DB2 table using shell script dtidke Shell Programming and Scripting 0 06-24-2008 06:18 AM

All times are GMT -4. The time now is 10:07 PM.