You dont have enough real memory to allocate that SORTHEAP of 4096, so its
trying a lesser value. You either have a shortage
of real memory or your SHEAPTHRES is set too low or you have INTRA_PARALLEL
set to yes and the SORTHEAP is coming
out of shared memory and there isnt enough there. So you have options to
choose from for what is the real problem.






"CS CS "
<db2udbdba-ezmlms
hield-x42543647.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
04/20/2006 03:08
AM Subject
(malloc()) failure.errno =
0x2FF1ADF0










My diag out put :
2006-04-20-04.10.08.640314
Instance:db2inst1 Node:000
PID:1020154(db2agent (test) 0)
TID:1 Appid:AC1908D3.AFF6.010AA277E689
oper system services MemAllocate Probe:203 Database:test

OS memory allocation (malloc()) failure.errno = 0x2FF1ADF0 : 0x0000000C
....

2006-04-20-04.10.08.644736
Instance:db2inst1 Node:000
PID:1020154(db2agent (test) 0)
TID:1 Appid:AC1908D3.AFF6.010AA277E689
sort/list services sqlsAllocateSortMemory Probe:35
Database:test

Not enough memory available for a (private) sort heap of size 4096
Trying smaller size...

how to trouble shoot this ?

CS






---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page