I'm curious about rollback process.

yowoseo · Post by **yowoseo** » Thu Mar 17, 2011 2:42 am

Hi all.

I'm a beginner about Datastage.

i'd like to delete parallel job with datastage version 7.5.2.

there are 2-ways to delete job.

one is write method=Load and using Close / Open command with user defined sql to delete.

the other is write method = delete.

My question is when the job kill after it started, how to process rollback?

i mean, there are different rollback process between 2-ways?

i think,

when i using user-defined sql, it still prcess the sql...

and method = delete can rollback automatically..

Am I right?

i'm using Oracle.

chulett · Post by **chulett** » Thu Mar 17, 2011 6:28 am

Nope, it all depends on your commit level (i.e. how often you commit) and whether the job aborts or not. Only an Abort will result in a rollback and then only for any uncommitted records, this regardless of the delete method used.

yowoseo · Post by **yowoseo** » Thu Mar 17, 2011 7:52 am

thank you so much~!