Hello Everyone,
I have a mixed workload DB2 UDB 8.2 FP 14 Windows x64 database. The
database performs as per the expectations. I have just one small
question. The sort related parameters are configured as follows:
Sort heap threshold (4KB) (SHEAPTHRES) = 50000
Sort list heap (4KB) (SORTHEAP) = 4096
According to the snapshots samples (taken over 3 or 4 snapshots over a
period of day):
Total sorts = 503094649
Total sort time (ms) = 506093220
Sort overflows = 4730618
I notice that the sort overflow is less than 1 percent, and in my
opinion it does not require any tuning. Just want to know what your
opinion is, do you think that sort overflow < 1% is still a concern
and necessary tuning at DB2 or application level is still needed?
regards,
dotyet
3  3201 
just one more thing, when I said:
I notice that the sort overflow is less than 1 percent, and in my
opinion it does not require any tuning.
I meant to say, that instead of spending the necessary time on this
configuration parameter, I will look at the other ones and continue
therefrom.
regards,
dotyet
On Sep 4, 1:15 pm, dotyet <dot...@yahoo.c omwrote:
Hello Everyone,
I have a mixed workload DB2 UDB 8.2 FP 14 Windows x64 database. The
database performs as per the expectations. I have just one small
question. The sort related parameters are configured as follows:
Sort heap threshold (4KB) (SHEAPTHRES) = 50000
Sort list heap (4KB) (SORTHEAP) = 4096
According to the snapshots samples (taken over 3 or 4 snapshots over a
period of day):
Total sorts = 503094649
Total sort time (ms) = 506093220
Sort overflows = 4730618
I notice that the sort overflow is less than 1 percent, and in my
opinion it does not require any tuning. Just want to know what your
opinion is, do you think that sort overflow < 1% is still a concern
and necessary tuning at DB2 or application level is still needed?
regards,
dotyet
"dotyet" <do****@yahoo.c omwrote in message
news:11******** **************@ r29g2000hsg.goo glegroups.com.. .
Hello Everyone,
I have a mixed workload DB2 UDB 8.2 FP 14 Windows x64 database. The
database performs as per the expectations. I have just one small
question. The sort related parameters are configured as follows:
Sort heap threshold (4KB) (SHEAPTHRES) = 50000
Sort list heap (4KB) (SORTHEAP) = 4096
According to the snapshots samples (taken over 3 or 4 snapshots over a
period of day):
Total sorts = 503094649
Total sort time (ms) = 506093220
Sort overflows = 4730618
I notice that the sort overflow is less than 1 percent, and in my
opinion it does not require any tuning. Just want to know what your
opinion is, do you think that sort overflow < 1% is still a concern
and necessary tuning at DB2 or application level is still needed?
regards,
dotyet
1% sort overflow is pretty good. But it really depends on the size of the
sorts that are overflowing from memory to disk. If you have very large sorts
overflowing, then higher than 1% may also be good. You cannot reasonably
expect to allocate enough resources to have very large sorts done totally in
memory.
Nice.... Thats exactly what I was thinking.... This is not a pure OLTP
environment, and many a times, some sort of reporting jobs are
executing on stipulated time-periods, possibly causing the overflow
due to the sort size.
Many thanks.
regards,
dotyet
On Sep 4, 6:41 pm, "Mark A" <nob...@nowhere .comwrote:
"dotyet" <dot...@yahoo.c omwrote in message
news:11******** **************@ r29g2000hsg.goo glegroups.com.. .
Hello Everyone,
I have a mixed workload DB2 UDB 8.2 FP 14 Windows x64 database. The
database performs as per the expectations. I have just one small
question. The sort related parameters are configured as follows:
Sort heap threshold (4KB) (SHEAPTHRES) = 50000
Sort list heap (4KB) (SORTHEAP) = 4096
According to the snapshots samples (taken over 3 or 4 snapshots over a
period of day):
Total sorts = 503094649
Total sort time (ms) = 506093220
Sort overflows = 4730618
I notice that the sort overflow is less than 1 percent, and in my
opinion it does not require any tuning. Just want to know what your
opinion is, do you think that sort overflow < 1% is still a concern
and necessary tuning at DB2 or application level is still needed?
regards,
dotyet
1% sort overflow is pretty good. But it really depends on the size of the
sorts that are overflowing from memory to disk. If you have very large sorts
overflowing, then higher than 1% may also be good. You cannot reasonably
expect to allocate enough resources to have very large sorts done totally in
memory.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Gram |
last post by:
Hello,
Can anyone help out with a bubble sort for strings using ASP? I have a text
file of words id like to sort and count.
Thanks in advance for any help.
Gram.
|
by: JerryJ |
last post by:
I have to fetch values from a database and store them in a vector in
my c++ application.
What is faster? if i fetch the values sorted from the database with a
'order by' clause in the sql-statement or if i fetch them into the
vector unsorted and sort the vector then?
Thanx for your help
|
by: Ireneusz SZCZESNIAK |
last post by:
I want to sort a vector with the std::sort function. There are two
functions: one with two arguments, the other with three arguments. I
am using the one with three arguments. I noticed that there is a huge
overhead of using this function, which comes from copying the function
object, i.e., the object that compares the elements of the vector,
which is passed to the function not by reference but by value.
Now, at the end of this mail...
|
by: yeti349 |
last post by:
Hi, I'm using the following code to retrieve data from an xml file and
populate a javascript array. The data is then displayed in html table
form. I would like to then be able to sort by each column. Once the
array elements are split, what is the best way to sort them? Thank you.
//populate data object with data from xml file.
//Data is a comma delimited list of values
var jsData = new Array();
jsData = {lib: "#field...
|
by: Alex Chudnovsky |
last post by:
I have come across with what appears to be a significant performance bug in
..NET 2.0 ArrayList.Sort method when compared with Array.Sort on the same
data. Same data on the same CPU gets sorted a lot faster with both methods
using .NET 1.1, that's why I am pretty sure its a (rather serious) bug. Below
you can find C# test case that should allow you to reproduce this error, to
run it you will need to put 2 data files into current directory...
| | |
by: akameswaran |
last post by:
Disclaimer - I recognize this is not a practical exercise. There are
many implementations around that would do the job better, more
efficiently (Meaning in C) or whatever.
I caught some thread about sorting and started thinking about shell
sort.... and as part of my trying to pythonise my mind and break my
java mindset
So I decided to tackle this old school problem with the python mindset.
|
by: Woody Ling |
last post by:
In 32 bits DB2 environment, is it meaningful to set sheapthres larger
than 256MB for the following case..
1. Intra-parallel is ON
2. Intra-parallel is OFF
|
by: JosAH |
last post by:
Greetings,
I was asked to write a Tip Of the Week; so here goes: a lot of topics are
started here in this forum (and a lot of other forums too) mentioning a
problem about sorting data.
Examples of two main problem scenarios are like this:
1) an array containing a first name and another array containing a last name
and possibly a third array containing the age of a person; how to sort the
|
by: t3chn0n3rd |
last post by:
Do you think it is relatively easy to write sort algorithms such as
the common Bubble sort in Python as compared to other high level
programming langauges
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
