error executing a query.

georgipa · #1 (**permalink**) 11-19-12, 12:08

Good afternoon,

I have DB2 V8 on AIX 5.3.

In the database was running a process and it has given this error:
SQL0955C Sort memory cannot be allocated to process the statement. Reason
code = "2".

Any help will be greatly appreciated.

Thank you very much.

ARWinner · #2 (**permalink**) 11-19-12, 12:49

From the manual:

Code:

SQL0955C  Sort memory cannot be allocated to process the statement.
      Reason code = "<reason-code>".

Explanation:

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

User response:

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.

 sqlcode: -955

 sqlstate: 57011

Andy

georgipa · #3 (**permalink**) 11-19-12, 13:03

thanks for your prompt response,

I have read that in the documentation, the parameter has this value:
Sort heap thres for shared sorts (4KB) (sheapthres_shr) = 40000

There is a formula to calculate the value of this parameter must have?

Greetings.

ARWinner · #4 (**permalink**) 11-19-12, 13:16

What does the manual say?

Andy

georgipa · #5 (**permalink**) 11-20-12, 09:30

My question is how many pages increase the parameter sheapthres_shr?

Thank you.

ARWinner · #6 (**permalink**) 11-20-12, 09:37

I cannot give you an answer, because it depends on numerous things--none of which you have supplied. You need to read the manual and apply it to your situation.

Andy

Internet Services

Web Development

Digital Marketing

Consumer Tech