I am getting an "Invalid private sort memory request" error in my
db2diag.log. I searched through the various knowledgebases and newsgroups
but couldn't find a note on this error.
2003-06-16-09.16.21.765000 Instance:DB2 Node:000
PID:2540(db2syscs.exe) TID:2616 Appid:GA646471.C538.013B46071509
sort/list services sqlsReservePrivateSpace Probe:10 Database:DB81
Invalid private sort memory request
0x493DC078 : 0x80000000 ...?
Version of both database and client is V8.1 FixPak 2 on Windows 2000 32-bits
My query is part of a stored procedure and consists of multiple joines
between tables, including two subqueries to two different GLOBAL TEMPORARY
TABLEs. The query contains an ORDER BY clause. I was not able to isolate the
problem to just a small portion of the query.
My DBM CFG settings regarding sort heap:
Minimum committed private memory (4KB) (MIN_PRIV_MEM) = 32
Private memory threshold (4KB) (PRIV_MEM_THRESH) = 32767
Sort heap threshold (4KB) (SHEAPTHRES) = 26044
I've increased the SHEAPTHRES parameter but that did not have effect.
DB CFG settings:
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = (SHEAPTHRES)
Sort list heap (4KB) (SORTHEAP) = 520
I do not have any OS problems regarding memory.
Thanks for any suggestions,