.net and db2.net provider issu

Hi all
I have
a service whihc accessed a db2 procedure using db2.net provider. My issue right now is that procedure is taking lot of memory space in db2 server.
The procedure returns the resultset to the client. I get the resultset in a reader and loop through the data to do some buisiness logic.

Note : this procedure is used extensively.

What am I doing wrong?
Thanks
rareach

re: .net and db2.net provider issu

You may be selecting more data than you need to. Perhaps you can break up the tasks instead of trying process all the data at once...