If I have two or more links going into a DB2-connector, will whatever the first link does be rolled back if the second link fails? E.g. if I first do a delete operation, and then an insert, and the insert fails, will the delete be automatically rolled back?
If not, is there any quick way of fixing this, any settings or such that can be adjusted, or any other smart solutions?
Rollback when using multiple input links
Moderators: chulett, rschirm, roy
If you have multiple links into the same target stage, then yes an abort during any operation will rollback whatever hasn't been committed at that point in all of the links. At least that was my experience in the past in a pre-connector world, so assuming (for better or worse) that it still works that way since all the work is done via a single database connection.
Of course, running on multiple nodes will complicate things as it usually does.![Wink :wink:](./images/smilies/icon_wink.gif)
Of course, running on multiple nodes will complicate things as it usually does.
![Wink :wink:](./images/smilies/icon_wink.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers