Four Stars

commitcount in delete DB2

Good evening.
I must perform a delete in a DB2 table.
This delete will remove 5 million rows.
This is a problem for the transaction log: maybe I can have an error "Transaction log full" from the database.
Can I specify a commitcount for a DELETE in a Talend component (tdb2ROw...)?
I tried to use tdb2row and set commit_every in advanced, but I think it is not working.
Can you help me please?
Community Manager

Re: commitcount in delete DB2

Do you use an existing DB connection or create the DB connection on the component itself? If latter, the component will commit every N rows based on the value you configured.
Talend | Data Agility for Modern Business