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