If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
SQL0955C Sort memory cannot be allocated to process the statement.
Reason code = "<reason-code>".
Insufficient virtual memory is available to the database agent for sort
processing, as indicated by the reason code:
1 Insufficient private process memory.
2 Insufficient shared memory in the database-wide shared memory
area designated for sort processing.
The statement cannot be processed but other SQL statements may be
One or more of the following:
* Decrease the value of the sort heap parameter ( sortheap) in the
corresponding database configuration file.
* For reason code 1, increase the private virtual memory available, if
possible. For example, on UNIX systems you can use the ulimit command
to increase the maximum size of the data area for a process.
* For reason code 2, increase the size of the database-wide shared
memory area designated for sort processing by increasing the value of
the SHEAPTHRES_SHR database configuration parameter.