Hyperthreading / Linux / DB2 V8.1 FP4 - performance

joerg

Hello,
we investigated a performance-drop while using DB2 V8.1 on a
Linux-Server (SuSE - SLES) and Hyperthreading activated. (Dual XEON
2.4 2GB)

The intraparallel-option is set and the client establishes 10
independant threads.
With hyperthreading activated, the performance drop with factor 2 (4
min -> 8 min). Is there any possibility to configure DB2 to use this
feature ?

Thanks

Joerg

Nov 12 '05 #1

Subscribe Post Reply

2293

Fan Ruo Xin

joerg wrote:

Hello,
we investigated a performance-drop while using DB2 V8.1 on a
Linux-Server (SuSE - SLES) and Hyperthreading activated. (Dual XEON
2.4 2GB)

The intraparallel-option is set and the client establishes 10
independant threads.
With hyperthreading activated, the performance drop with factor 2 (4
min -> 8 min). Is there any possibility to configure DB2 to use this
feature ?
All DB2 EDUs are implemented as processes on UNIX and Linux.

Thanks

Joerg

Nov 12 '05 #2

Similar topics

Java and hyperthreading

by: BlackHawke | last post by:

Hello! I have a java application (a game) which is supposed to run as a server. It is on a dedicated machine with MP capabilities, but currently running 1 Xeon processor with hyperthreading. ...

Java

help! multi-threading problem on hyperthreading smp linux server

by: Garry Hodgson | last post by:

a colleague of mine has seen an odd problem in some code of ours. we initially noticed it on webware, but in distilling a test case it seems to be strictly a python issue. in the real system, it...

Python

p4 hyperthreading & web gardening

by: Param - Home | last post by:

Hi all, we are in the process of getting a new server and wanted to know whether it is worth getting a dual cpu or just a single cpu like a p4 3ghz with hyperthreading? How does asp.net web...

ASP.NET

Hyperthreading slows down server

by: javed74 | last post by:

Hi Guys, We just deployed our asp.net application on Xeon dual processor with Hyperthreading turned on. OS Windows 2003 (Web Edition) .NET Framework 1.1 While stress testing with 1 wp, we get...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA