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 IC91758 Status: Closed

DB2 REPORTS NUMBER OF PROCESSOR CORES WITH INTEL HYPERTHREADING INCORRECTLY
(CONTINUATION OF IC81317 )

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
Apar IC81317 not completely fixed. 
DB2 on a HP server with two Intel(R) Xeon(R) CPU E5-2665 with 8 
cores each, in sum 16 cores. 
Hyperthreading is activated so DB2 sees 32 cores on a Windows 
OS. 
 
The db2diag.log of the server described above shows following 
values: 
 
 
CPU: total:32 online:32 Cores per socket:1 Threading degree per 
core:2 
 
 
Correctly in customers view would be: 
 
 
 
CPU: total: 2 online: 2 Cores per socket:8 Threading degree per 
core:2 
 
 
In summary this is the third attempt to display the correct CPU 
information. 
 
 
 
 
- db2diag.log : 
 
Instance "DB2" uses "64" bits and DB2 code release "SQL09076" 
with level identifier "08070107". 
Informational tokens are "DB2 v9.7.600.413", "s120516", 
"IP23323", Fix Pack "6". 
DATA #2 : System Info, 1568 bytes System: WIN32_NT AT010000SA134 
Service Pack 1 6.1 AMD64 Family 6, model 45, stepping 7 
CPU: total:32 online:32 Cores per socket:1 Threading degree per 
core:2 
 
 
- db2pd -osinfo : 
 
Operating System Information: 
 
OSName:   WIN32_NT 
NodeName: AT010000SA134 
Version:  6.1 
Release:  Service Pack 1 
Machine:  AMD64 Family 6, model 45, stepping 7 
 
CPU Information: 
TotalCPU    OnlineCPU   ConfigCPU   Speed(MHz)  HMTDegree 
Cores/Socket 
32              32          32          2394        2 
1 
 
Physical Memory and Swap (Megabytes): 
TotalMem    FreeMem     AvailMem    TotalSwap   FreeSwap 
32734       29060       29060       33032       33007 
 
Virtual Memory (Megabytes): 
Total       Reserved    Available   Free 
65766       n/a         n/a         62064 
 
CPU Usage Information (percent): 
Total     Usr       Sys       Wait      Idle 
0.005769  0.000000  0.000000  0.000000  99.994231
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* HP users                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V10.1 FP3                                         * 
****************************************************************
Local Fix:
N/A
available fix packs:
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
First fixed in V10.1 FP3
Workaround
N/A
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.04.2013
11.11.2013
11.11.2013
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.3 FixList
10.1.0.3 FixList