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?
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.
