home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC78718 Status: Closed

DB2 REPORTS NUMBER OF PROCESSOR CORES WITH INTEL HYPERTHREADING INCORRECTLY

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
DB2 incorrectly counts a core which is Intel HyperThreading as 
two cores. It should be counted as 1 core with threading level 
of 2 for the purpose of license enforcement. Our license text 
explicitly states limits as based on cores rather than Intel 
"threads". 
 
Correct output should be 
Dual X5560 (2 socket) 
CPU: total:16 online:16 Cores per socket:4 Threading degree per 
core:2 
 
Instead in db2diag.log it reports 
CPU: total:16 online:16 Cores per socket:8 Threading degree per 
core:1 
 
This can also be displayed via db2pd -osinfo. 
 
The output we are looking for will be similar to 
 
CPU Information: 
TotalCPU    OnlineCPU   ConfigCPU   Speed(MHz)  HMTDegree 
Cores/Socket 
8           8           8           1648        2           n/a
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 Express-C and DB2 Express users running on hardware with * 
* Intel processor(s) that have Hyperthreading                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2 Express-C and DB2 Express will only use half the         * 
* physical CPU cores they should, because Hyperthreading will  * 
* make it look as though the computer has twice as many cores  * 
* as it actually does.                                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7fp6                                       * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
15.09.2011
06.02.2012
06.02.2012
Problem solved at the following versions (IBM BugInfos)
9.7.FP6
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.5 FixList