Rollback when using multiple input links

[stiantok]

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?

[qt_ky]

You may want to look into the Distributed Transaction Stage to see if that will handle it as you described.

[chulett]

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.