On 2/11/2016 12:41 PM, Troels Arvin wrote:
> With such a server:
> Two Intel Xeon E5-2643 v3, each having six cores.
> �TB RAM
> Red Hat Enterprise Linux 7.2
> DB2 v. 9.7 (latest fixpack level)
> And with a datawarehouse workload with many long-running loads, inserts,
> selects, including heavy joins.
> Would you turn hyperthreading on or off in the server?
Impossible to tell from your short comments. There are way too many
variables involved, not the least is what else is running on the
machine. I've seen it help and I've seen it hurt.
Like any other tuning parameter - I would suggest you turn it on and see
if it helps. Also, try tuning the other DB2 parameters, both with
hyperthreading on and off, until you find the best performance for your
situation. Every one is unique.
Remove the "x" from my email address