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

DB2 - Tracking Table history

👤 Login to reply

Old 12-18-2017
Perlbaby Perlbaby is offline
Registered User
Join Date: Oct 2011
Last Activity: 6 June 2018, 4:00 AM EDT
Posts: 69
Thanks: 10
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 12-18-2017
rbatte1 rbatte1 is offline Forum Staff  
Root armed
Join Date: Jun 2007
Last Activity: 20 July 2018, 11:57 AM EDT
Location: Lancashire, UK
Posts: 3,588
Thanks: 1,594
Thanked 706 Times in 633 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
👤 Login to reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 09:03 PM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
Show Password

Not a Forum Member?
Forgot Password?