Ramc Natarajan created TEIIDDES-1892: ---------------------------------------- Summary: memory management issue Key: TEIIDDES-1892 URL: https://issues.jboss.org/browse/TEIIDDES-1892 Project: Teiid Designer Issue Type: Quality Risk Components: Teiid Integration Affects Versions: 7.7.4 Environment: jboss Reporter: Ramc Natarajan Hi , I have created a view in teiid and deployed in a vdb. then When I was trying to move the data from the deployed vdb to my target database using my isw designer(ETL tool). But I could move only 3900000 records only. When I tried to move 4000000 records I got an error that the result set is closed and about the jar file. Now my source database is 9.7.4 db2 database and target is 9.7.4 db2 database. My Isw designer is 10.1. and the source table contains almost 35000000 records that is 25.6 GB. Please let me know what is the maximum size of data can be movable through Jboss(EDS Server).I have checked the file and it shows that the max file size is 2 GB(default). I changed it to 6 GB but still I am getting the same error. How to increase the the performance here. In document I have read that we have to increase the maxprocessingkb and decrease the maxreservekb. How to do it? It has given as -1 as default that means auto calculate. Can't we transfer more than 2GB of data through Jboss ?? My source table contains 94 columns so 39 lakhs records will be around 2GB. Please help me out of this. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira