By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,874 Members | 1,058 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,874 IT Pros & Developers. It's quick & easy.

Sort heap question

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.