Impact of using BT/ET on set of DMLs for huge volume of data

Database

Impact of using BT/ET on set of DMLs for huge volume of data

Hi There

We have a bteq which does DML operation on a set of tables those contains huge volum of data.

Till now we dont have BT/ET mode in the bteq.so each dml request is committed.
if any failure happens in between then the DMLs that are executed before this failure can not be rolled back.

So we want to introduce BT before the start of BTEQ and ET before end of bteq to commit all requests at a time.

Could you please let us know the impacts due to this?

will there be any performance issue can happen because of this?
1 REPLY
Enthusiast

Re: Impact of using BT/ET on set of DMLs for huge volume of data

I am looking for an answer on this as well. 

I have below questions.
1. Where does teredata store the redo log for the DML's executed in BT/ET?

2. I will have mulitple jobs which will be triggered simultaneously invoking BT/ET using same id. Will this cause any performance bottleneck or impact system in any form?