Joined: 05 Dec 2006 Posts: 153 Location: Seattle, WA
Double check your space allocations for your session. Sounds like you need to increase it - but check with your systems people to make sure you haven't maxed out your session.
If so, think carefully about what your expected results are. If your session is already set to the max and you are still having memory problems, it sounds like you are asking FA DB2 to do too much in an online session and should seriously consider doing the work in a batch job.