0

I have been searching for the condition, where, lets say when we enable time travel to a certain table in DB2 , but don't want to capture all the updates done, but only the updates that's done by some specific user.

Wanted to know if this is at all possible with the DB2 time travel and how we can achieve it .

  • No, it's not possible. You'll have to roll your own, e.g. using a trigger. – mustaccio Nov 22 '18 at 13:49
1

With Db2 (LUW) Temporal Tables, there is not any option to exclude updates from a certain user.

However, the SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY procedure is available, and can be called by a user (if a user is granted permission on it), and this will disable the recording of temporal history for system-period temporal tables with the the duration of the current session.

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0060661.html

Set the internal option to disable recording of temporal history for a system-period temporal table and allow values to be specified for the special temporal columns.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.