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

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.