Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-10-07 12:01 PM

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?
Labels (2)
Labels
431 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2015-10-12 03:33 AM
Author

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.
431 Views
0 Likes