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 IC91989 Status: Geschlossen

QUERY WITH TABLESAMPLE SYSTEM() MIGHT HANG IN SMP MODE (INTRA_PARALLEL =
YES)

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
A query with TABLESAMPLE SYSTEM() might hang if it runs in 
parallel mode, i.e. INTRA_PARALLEL = YES. 
 
This issue was observed with ADMIN_MOVE_TABLE function which 
might use such queries starting with DB2 v10.1 Fixpack 1 (see 
also APAR IC84414). 
 
You might see a query like the following when executed with sub 
agents to hang: 
 
SELECT ... 
FROM <table> TABLESAMPLE SYSTEM() WITH UR; 
 
A stack trace against the coordinating agent might show 
"sqkfChannel::WaitRecvReady" function waiting to receive data 
from sub agents: 
 
ossDumpStackTraceInternal 
ossDumpStackTrace 
OSSTrapFile::dumpEx 
sqlo_trce 
sqloDumpDiagInfoHandler 
semtimedop 
sqloWaitEDUWaitPost 
sqkfChannel::WaitRecvReady 
sqkfChannel 
sqlkqrcv 
sqlktrcv 
sqlkt_unpack_tuple 
sqlktftc 
sqlritqa 
sqlriSectInvoke 
sqlrr_process_fetch_request 
sqlrr_open 
sqljs_ddm_opnqry 
sqljsParseRdbAccessed 
... 
 
but in application snapshot there are no associated sub agents 
anymore.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 3.                      * 
****************************************************************
Local-Fix:
Do not use INTRA_PARALLEL, or turn parallelism off for the 
query, i.e.: SET CURRENT DEGREE = '1'
verfügbare FixPacks:
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

Lösung
First fixed in DB2 Version 10.1 Fix Pack 3.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC95295 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
30.04.2013
27.09.2013
27.09.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.3 FixList
10.1.0.3 FixList