470,594 Members | 1,556 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,594 developers. It's quick & easy.

Sort heap question

Raj

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

Jan 19 '07 #1
0 2360

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

25 posts views Thread by Rainmaker | last post: by
2 posts views Thread by Raj | last post: by
5 posts views Thread by jason735 | last post: by
reply views Thread by Raj | last post: by
reply views Thread by JosAH | last post: by
3 posts views Thread by dotyet | last post: by
9 posts views Thread by sophia.agnes | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.