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
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