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

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

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
This APAR includes the complete fix for IC81317. 
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 
 
 
The correct output should be: 
 
 
 
CPU: total: 2 online: 2 Cores per socket:8 Threading degree per 
core:2 
 
- 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:                                              * 
* Windows                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.7 FixPack 8                     * 
****************************************************************
Local Fix:
N/A
available fix packs:
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
Problem was first fixed in DB2 UDB Version 9.7 FixPack 8
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC91758 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
21.08.2012
01.04.2013
18.08.2014
Problem solved at the following versions (IBM BugInfos)
9.7.FP8
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.8 FixList