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

APPLICATION SNAPSHOT FIELD FOR TABLE QUEUES SHOWS INCORRECT PARTITION
NUMBER

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
A table queue is the mechanism by which agents that are 
executing a query can transfer rows back and forth. 
 
In the application snapshot, if a particular subsection is 
waiting for another partition to respond on the tablequeue, the 
following snapshot field will tell you which partition it's 
waiting for: 
"Node for which waiting on tablequeue" 
There is a problem with this field of the snapshot where it may 
report the incorrect partition number.  This defect will fix 
this monitor field to ensure the reported partition number is 
correct.
Problem Summary:
A table queue is the mechanism by which agents that are 
executing a query can transfer rows back and forth. 
 
In the application snapshot, if a particular subsection is 
waiting for another partition to respond on the tablequeue, the 
following snapshot field will tell you which partition it's 
waiting for: 
"Node for which waiting on tablequeue" 
There is a problem with this field of the snapshot where it may 
report the incorrect partition number.  This defect will fix 
this monitor field to ensure the reported partition number is 
correct.
Local Fix:
No known local fix
available fix packs:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows

Solution
First first in the DB2 V9.7 fixpak 2
Workaround
No known Temporary fix.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
28.10.2009
13.05.2010
13.05.2010
Problem solved at the following versions (IBM BugInfos)
9.7.
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.2 FixList