db2 stored procedure

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rareach
    New Member
    • Oct 2008
    • 2

    db2 stored procedure

    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
Working...