Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    415

    error executing a query.

    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.
    DBA DB2 for LUW

  2. #2
    Join Date
    Jan 2003
    Posts
    4,147
    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

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    415
    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.
    DBA DB2 for LUW

  4. #4
    Join Date
    Jan 2003
    Posts
    4,147
    What does the manual say?

    Andy

  5. #5
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    415
    My question is how many pages increase the parameter sheapthres_shr?

    Thank you.
    DBA DB2 for LUW

  6. #6
    Join Date
    Jan 2003
    Posts
    4,147
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •