[CR #494304] If you run a query in the Query Designer to retrieve records from a table containing 10000 or more records, ETL may stop responding if you enter 0 as the number of records to return in one of:
Query Designer window.
A query you create from the Properties window for the component.
File | Preferences | Workbench | Query Designer | Default number of records to retrieve from Query Designer.
ETL should return all rows in the result set if you specify 0 but stops responding because the Java virtual machine cannot obtain enough memory to display the result set.
Workaround: Increase the maximum heap size the Java virtual machine can address; change the default -Xmx256M to -Xmx512M in the IQETLDev.lap file in the ETL installation directory.
