Page 1 of 1
Rollback when job finishes with warnings
Posted: Wed Nov 08, 2006 8:29 am
by dsscholar
I am inserting data in DB2 table and I have set transactional handling as 0 to rollback in case the load doesnt finish sucessfully. My question is whether rollback will take place only if the job fails/aborts or even if the job finishes with warnings ?
Thanks
Posted: Wed Nov 08, 2006 8:30 am
by chulett
The job has to Abort to initiate the rollback.
Posted: Wed Nov 08, 2006 8:45 am
by dsscholar
Thanks Craig..
Posted: Wed Nov 08, 2006 9:37 am
by tagnihotri
Although just to point out, you may have cases of dataloss even if the job finishes with warning
dsscholar wrote:Thanks Craig..
Posted: Wed Nov 08, 2006 10:28 pm
by loveojha2
Do get rid of such a dataloss case, make sure your job aborts even when it generates a warning, if that's what you want.
Posted: Wed Nov 08, 2006 11:08 pm
by tagnihotri
Aborting job even when you get any warning hmmmmm
You need to be preety sure if you need this, as in many cases I have seen dataloss with warnings but its not always. So you may end up aborting your job in half way even when you get "informative" warnings.
loveojha2 wrote:Do get rid of such a dataloss case, make sure your job aborts even when it generates a warning, if that's what you want.
Posted: Thu Nov 09, 2006 2:18 am
by loveojha2
loveojha2 wrote:Do get rid of such a dataloss case, make sure your job aborts even when it generates a warning, if that's what you want.
Just a typo
To get rid of such a dataloss case, make sure your job aborts even when it generates a warning, if that's what you want.