When does DS issue RDBMS commits
Posted: Thu Jul 05, 2007 2:17 am
Apols for an easily tested question, but I don't have an instance of DS at the moment to test it on.
If you have a job with multiple pipelines, does an OCI stage perform its final commit immediately after the last row / after-SQL is processed, or does it wait until the end of the job.
Does it go: Process all txns through A & B, Commit link B, Process all txns through C and D, Commit link D
Or is it: Process all txns through A & B, Process all txns through C and D, Commit links B and D.
I suspect it is the first one, I just want to make sure.
If you have a job with multiple pipelines, does an OCI stage perform its final commit immediately after the last row / after-SQL is processed, or does it wait until the end of the job.
Code: Select all
OCI ----> TX -----> OCI -----> TX ----> OCI
A B C D
Or is it: Process all txns through A & B, Process all txns through C and D, Commit links B and D.
I suspect it is the first one, I just want to make sure.