home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT06477 Status: Geschlossen

DB2PD -ALLDBS -INST CAN LOOP CONTINUOUSLY ON SYSTEMS WITH VERY LARGE
BUFFERPOOL CONFIGURATIONS

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
"db2pd -alldbs -inst" can loop displaying information like this: 
 
Instance db2inst1 uses 64 bits and DB2 code release SQL10053 
with level identifier 0604010E 
Informational tokens are DB2 v10.5.0.3, s140203, IP23551, Fix 
Pack 3. 
 
Operating System Information: 
 
OSName:   Linux 
NodeName: test.ibm.com 
Version:  2 
Release:  6 
Machine:  x86_64 
Distros:  Red Hat Enterprise Linux Server 6.2 
 
 
CPU Information: 
TotalCPU    OnlineCPU   ConfigCPU   Speed(MHz)  HMTDegree 
Cores/Socket 
40          20          40          2261        1           10 
 
 
Physical Memory and Swap (Megabytes): 
TotalMem    FreeMem     AvailMem    TotalSwap   FreeSwap 
1034132     947         n/a         409600      323023 
 
Virtual Memory (Megabytes): 
Total       Reserved    Available   Free 
1443732     n/a         n/a         323969 
 
Message Queue Information: 
MsgSeg      MsgMax      MsgMap      MsgMni      MsgTql 
MsgMnb      MsgSsz 
n/a         65536       65536       1034240     65536 
65536       16 
 
Shared Memory Information: 
ShmMax               ShmMin               ShmIds      ShmSeg 
 
1084365606912        1                    258560      258560 
 
 
Semaphore Information: 
SemMap      SemMni      SemMns      SemMnu      SemMsl 
SemOpm      SemUme      SemUsz      SemVmx      SemAem 
256000      258560      256000      256000      1175000     32 
n/a         20          32767       32767 
 
CPU Load Information: 
Short     Medium    Long 
61.140000 52.210000 30.560000 
 
CPU Usage Information (percent): 
Total     Usr       Sys       Wait      Idle 
100.00000 n/a        n/a        n/a        0.000000 
 
.... 
 
db2pd can also be seeing growing in virtual memory. 
 
This problem will only occur on environments with very large 
bufferpool configurations. 
 
Note:  db2pd -alldbs -inst is also issued by db2fodc -hang 
implicitly.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7, Fix pack 11                      * 
****************************************************************
Local-Fix:
Manually kill db2pd after the data has been collected.
Lösung
First fixed in DB2 Version 9.7, Fix pack 11
Workaround
see Local Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
13.01.2015
08.10.2015
08.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP11
Problem behoben lt. FixList in der Version
9.7.0.11 FixList