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

What is this referring to in the Administration Guide: Performance

P: n/a
Hi all,

I was doing some research on tuning sheapthres and sortheap and ran
accross this at the boulder public lib:
http://publib.boulder.ibm.com/infoce...n/c0005404.htm

In here it states:
__________________________________________________ __________________________
You can use the database system monitor and benchmarking techniques to
help set the sortheap and sheapthres configuration parameters. For each
database manager and its databases:

Set up and run a representative workload.
For each applicable database, collect average values for the following
performance variables over the benchmark workload period:
Total sort heap in use
Active sorts
Set sortheap to the average total sort heap in use for each database.
__________________________________________________ __________________________

What does it mean by "Total sort heap in use ". I looked up and down
in a snapshot against all monitors and did not find a parameter that
matched that. Where do I find this figure??

rdudejr

Aug 30 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I guess they mean the sort_heap_allocated element which is in sanpshots
at the db and dbm level
rdudejr wrote:
Hi all,

I was doing some research on tuning sheapthres and sortheap and ran
accross this at the boulder public lib:
http://publib.boulder.ibm.com/infoce...n/c0005404.htm

In here it states:
__________________________________________________ __________________________
You can use the database system monitor and benchmarking techniques to
help set the sortheap and sheapthres configuration parameters. For each
database manager and its databases:

Set up and run a representative workload.
For each applicable database, collect average values for the following
performance variables over the benchmark workload period:
Total sort heap in use
Active sorts
Set sortheap to the average total sort heap in use for each database.
__________________________________________________ __________________________

What does it mean by "Total sort heap in use ". I looked up and down
in a snapshot against all monitors and did not find a parameter that
matched that. Where do I find this figure??

rdudejr
Aug 30 '06 #2

P: n/a
SORTHEAP is a db cfg parm.
SHEAPTRESH is a DBM cfg parm.

Total sort heap is the summ total of all sortheaps assigned across all
databases of the instance at the time of the snapshot.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"rdudejr" <rd*****@gmail.coma écrit dans le message de news:
11**********************@i3g2000cwc.googlegroups.c om...
Hi all,

I was doing some research on tuning sheapthres and sortheap and ran
accross this at the boulder public lib:
http://publib.boulder.ibm.com/infoce...n/c0005404.htm

In here it states:
__________________________________________________ __________________________
You can use the database system monitor and benchmarking techniques to
help set the sortheap and sheapthres configuration parameters. For each
database manager and its databases:

Set up and run a representative workload.
For each applicable database, collect average values for the following
performance variables over the benchmark workload period:
Total sort heap in use
Active sorts
Set sortheap to the average total sort heap in use for each database.
__________________________________________________ __________________________

What does it mean by "Total sort heap in use ". I looked up and down
in a snapshot against all monitors and did not find a parameter that
matched that. Where do I find this figure??

rdudejr
Sep 2 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.