We have a concept in sql server as change tracking, that enables applications to obtain only changes(DML changes like Insert, Delete and Update) that have been made to the user tables, along with the information about those changes & we can easily disable these on a table in sql server.
Is there any functionality in db2luw, as i can do the same.
can some one kindly explain me this
Is this the same applicable for this too
ALTER TABLE tablename ACTIVATE NOT LOGGED INITIALLY
You should read the 1-st link to achieve what you have in MSSQL. 2-nd link can be useful for performance investigations mostly.
To start some particular table auditing you use AUDIT TABLE mytable USING POLICY mypolicy.
To stop some particular table auditing you use AUDIT TABLE mytable REMOVE POLICY.
You can audit entire database using the same policy with EXECUTE category but I wouldn't recommend it due to performance reasons.