SEO

We are on a db2 v8.2 (fix 8) with DPF & intra parllelism. Below are
sort related configuration settings


---------------------------------------------------------------------------*--------------------------------------------------------

Sort heap threshold (4KB) (SHEAPTHRES) = 200000
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = (SHEAPTHRES)



>From database snapshot @ global level:


---------------------------------------------------------------------------*--------------------------------------------------------

Total Private Sort heap allocated = 0
Total Shared Sort heap allocated = 0
Shared Sort heap high water mark = 0
Total sorts = 482304
Total sort time (ms) = 21254858
Sort overflows = 31026
Active sorts = 0

Node number = 0
Memory Pool Type = Shared Sort Heap
Current size (bytes) = 0
High water mark (bytes) = 0
Configured size (bytes) = 819216384


Node number = 1
Memory Pool Type = Shared Sort Heap
Current size (bytes) = 0
High water mark (bytes) = 0
Configured size (bytes) = 819216384


Node number = 2
Memory Pool Type = Shared Sort Heap
Current size (bytes) = 0
High water mark (bytes) = 0
Configured size (bytes) = 819216384


Node number = 3
Memory Pool Type = Shared Sort Heap
Current size (bytes) = 0
High water mark (bytes) = 0
Configured size (bytes) = 819216384


Node number = 4
Memory Pool Type = Shared Sort Heap
Current size (bytes) = 0
High water mark (bytes) = 0
Configured size (bytes) = 819216384


Node number = 5
Memory Pool Type = Shared Sort Heap
Current size (bytes) = 0
High water mark (bytes) = 0
Configured size (bytes) = 819216384
---------------------------------------------------------------------------*--------------------------------------------------------

How can the high water mark for private and shared sort be equal to
zero ??


Will the db allocate 200000 4k pages when the db is activated? I read
some where that SHEAPTHRES_SHR is preallocated as part of the database
shared memory, but I don't see any shsorth's allocated from db2mtrk -d


Thanks,
Raj