https://community.qlik.com/t5/Talend-Studio/commitcount-in-delete-DB2/m-p/2247710#M32809 Good evening. <BR />I must perform a delete in a DB2 table. <BR />This delete will remove 5 million rows. <BR />This is a problem for the transaction log: maybe I can have an error "Transaction log full" from the database. <BR /> <B>Can I specify a commitcount for a DELETE in a Talend component (tdb2ROw...)?</B> <BR />I tried to use tdb2row and set commit_every in advanced, but I think it is not working. <BR />Can you help me please? Wed, 07 Oct 2015 16:01:25 GMT Anonymous 2015-10-07T16:01:25Z https://community.qlik.com/t5/Talend-Studio/commitcount-in-delete-DB2/m-p/2247710#M32809 Good evening. <BR />I must perform a delete in a DB2 table. <BR />This delete will remove 5 million rows. <BR />This is a problem for the transaction log: maybe I can have an error "Transaction log full" from the database. <BR /> <B>Can I specify a commitcount for a DELETE in a Talend component (tdb2ROw...)?</B> <BR />I tried to use tdb2row and set commit_every in advanced, but I think it is not working. <BR />Can you help me please? Wed, 07 Oct 2015 16:01:25 GMT https://community.qlik.com/t5/Talend-Studio/commitcount-in-delete-DB2/m-p/2247710#M32809 Anonymous 2015-10-07T16:01:25Z https://community.qlik.com/t5/Talend-Studio/commitcount-in-delete-DB2/m-p/2247711#M32810 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. Mon, 12 Oct 2015 07:33:18 GMT https://community.qlik.com/t5/Talend-Studio/commitcount-in-delete-DB2/m-p/2247711#M32810 Anonymous 2015-10-12T07:33:18Z