View previous topic :: View next topic
|
Author |
Message |
sri_mf
Active User
Joined: 31 Aug 2006 Posts: 218 Location: India
|
|
|
|
While working on File-Aid for DB2 i have come across this problem.
SQLP100C SQL Processor error - no storage available
how to solve this.Cna any one throw light on this |
|
Back to top |
|
|
socker_dad
Active User
Joined: 05 Dec 2006 Posts: 177 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. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Or limiting the set of data you want to work with. |
|
Back to top |
|
|
|