Handle exception case in database load failuare

prasson_ibm · Post by **prasson_ibm** » Thu Dec 13, 2012 2:39 am

Hi,

I need to handle the exception in case of load failed.Can i implement in datastage like ,i can commit the database once load get finished successfully otherwise if it get failed in between,i have to rollback.

Any suggestion.

Thanks
Prasoon

ray.wurlod · Post by **ray.wurlod** » Thu Dec 13, 2012 4:36 am

Yes you can, but you will want to become very good friends with the DBA if you want to create such enormous transactions!

prasson_ibm · Post by **prasson_ibm** » Fri Dec 14, 2012 3:46 am

Thanks ray for your reply.So better i am thinking to go for delete the commited data in case of batch failuar,but i am not sure how delete will perform on millions records,so in your view what will be best apporach to handle the batch fail.

Thanks
Prasoon

ray.wurlod · Post by **ray.wurlod** » Fri Dec 14, 2012 3:25 pm

DELETE is good but it, too, is transactional. Pour another beer down your DBA's throat.