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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nivedhitha
Creator III
Creator III

Improve performance of db2 to csv load

Hi everyone,

 

I have little more than 3 million records in my source db2 table. I m writing this to a csv file and it took 40 minutes for 2 million records and then failed with java heap space error. (around 600 records/s)

Note : I'm not creating the job in my local directory, in turn sending the data through output stream and creating the file on dropbox.

 

Can someone suggest me ways to increase performance in this case?

 

Thanks in advance for your help

Labels (4)
0 Replies