title: Datastage Heap Size
body: <p>Can you please help me, because am stuck with a problem of heap size.</p>
  
  <p>I am using a jdbc connector to connect to a PostgreSQL database. I have about 7 million data into my table. I had to set my heap size about 4096 Mb (4 GB) so that my job does not fail with the error:  </p>
  
  <blockquote>
    <p>java.lang.OutOfMemoryError: Java heap space</p>
  </blockquote>
  
  <p>So far I have not find a solution, to read data from this connector using Fetch Size just like Oracle Array Size. See below are the recommendations of IBM while using the fetch size.</p>
  
  <ol>
  <li>Single Query</li>
  <li>Auto Commit is disable</li>
  <li>Right use of charset and length of fields.</li>
  </ol>
  
  <p>All are set accordingly but we are unable to use the fetch size correctly. We have also tested it by using java language and the fetch size and it worked, so the problem may not be with the driver. </p>
  
  <p>Can you guys share your experience with me? Anyone had similar problems, how did you solved it except increasing the heap size. In fact we don't want to increase the heap size more than this, we would like to make the connector read small packets of data using a moderate heap size instead of using a rather big size heap size. </p>
  
  <p>Kind regards,<br>
  Knlix.</p>