I have a question related to IBM Data Studio Client 4.1.1 (Enterprise Edition) java heap space error. On running certain `select * from` queries, the client crashes and generates a heap file giving Java heap space error. I thought this issue might be resolved by increasing Java heap space, but I have already 1 GB of Java heap space allocated, and have 8GB of RAM in my system. I researched on the issue and found IBM document which is listed here:

<http://www-01.ibm.com/support/docview.wss?uid=swg21486423> 

To put it all together, I run a simple `select * from` query, the client brings up error message '**java heap space**' and a dump file is created on my computer in the *program files> IBM > SDP* folder. I seeked help from the IT team in my organization and nobody could figure out the issue, they kept reinstalling a different version of the client on the same workspace and settings because whenever I reopened the application after a new installation, all configurations and settings even the code I last wrote was retained as is, so maybe reinstallation is not the solution to my problem. How should I pursue this problem?