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
Rollback when job finishes with warnings
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 83
- Joined: Sat Oct 28, 2006 6:25 am
-
- Participant
- Posts: 83
- Joined: Sat Oct 28, 2006 6:25 am
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.
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.
Just a typoloveojha2 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.
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.
Success consists of getting up just one more time than you fall.