Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    60

    Unanswered: no memory available error

    Hi all,

    This is udb ver 8.1.6 on aix 5.2
    Some of our queries are getting following error
    SQLException [Sort memory cannot be allocated to process the statement. Reason code = "".];

    In diaglog following errors got logged :
    DIA8311C No memory available in the sort heap.
    ZRC=0x8B0F0033

    2005-02-26-17.10.32.277462 Instance:udbta042 Node:000
    PID:131972(db2agent (QACCABOD) 0) TID:1 Appid:GA570482.FD91.0102502009B1
    oper system services sqlofica Probe:10 Database:QACCABOD

    2005-02-26-17.10.32.302001 Instance:udbta042 Node:000
    PID:131972(db2agent (QACCABOD) 0) TID:1 Appid:GA570482.FD91.0102502009B1
    access plan manager sqlra_sqlW_mem_get_block Probe:100 Database:QACCABOD

    Private Workspace Overflow
    current heap size=842236
    memory_to_allocate =60
    mem_required =75
    amount_freed =0


    2005-02-26-17.10.32.323339 Instance:udbta042 Node:000
    PID:131972(db2agent (QACCABOD) 0) TID:1 Appid:GA570482.FD91.0102502009B1
    access plan manager sqlra_sqlW_mem_get_block Probe:100 Database:QACCABOD

    Private Workspace Overflow
    current heap size=842296
    memory_to_allocate =64
    mem_required =80
    amount_freed =0

    How do I fix this error. Can it be fixed by increasing sortheap or application heap?

    Thanks in advance
    j

  2. #2
    Join Date
    Aug 2004
    Posts
    138
    Increase the sort heap and sortheap thres. take a snapshot and find out high water mark for sort heap and increase your sortheap according to that. make sure to increase the sortheapthres also.

Posting Permissions

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