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... I don't see any shsorth's allocated from db2mtrk -d
Thanks,
Raj