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

TRAP IN SQLKQSND IN DPF ENVIRONMENT DURING RUNTIME OF SQL QUERIES HAVING
STACKED MDTQS

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
DB2 may trap and generate core file during runtime of SQL 
queries having stacked MDTQs. 
 
A stacked MDTQ is an access plan that features 2 merge TQ's on 
top of one another without having any damming operations like a 
SORT or a TEMP in between them.  The Bottom of the 2 merge TQ's 
is a merge directed TQ (MDTQ). The top one can be either 
directed or broadcast, but must still be a merging TQ (MDTQ, or 
MBTQ) 
 
for example: 
 
   ... 
   MBTQ 
      | 
  GRPBY 
      | 
   MDTQ 
     | 
 ... 
 
but: 
 
   MBTQ 
      | 
   SCAN 
      | 
   SORT 
      | 
   MDTQ 
 
..is not a stack MDTQ because there is a damming operation 
(SORT) in between them. 
 
The trap is timing-dependent, and the 
failure is seen during some runs of the query. 
 
Stack looks similar to IC95108 -- but has different cause. 
 
Stack #1             Signal #11        Timestamp 
2014-10-02-12.22.42.214367 
0        sqlkqsnd 
1        sqlktsnd 
2        sqlkt_pack_tuple 
3        sqlktins 
4        sqlritqb 
5        sqlriSectInvoke 
6        sqlrr_dss_router 
7        sqlrr_subagent_router 
8        sqleSubRequestRouter 
9        sqleProcessSubRequest 
10       sqeAgent::RunEDU 
11       sqzEDUObj::EDUDriver 
12       sqlzRunEDU 
13       sqloEDUEntry 
 
The problem is seen intermittently due to dependence on timing 
and presence of certain aggravating factors. Factors that work 
in combination to precipitate this error include -- 
1)Fetch first N rows - resulting in 'early-out' in access plan 
2)Stacked Merge table queue MDTQ 
3)Spilling table queue 
4)Flow of control messages 
5)Partition layout, and patterns in data
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW v10.1                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v10.1 Fix Pack 5                              * 
****************************************************************
Local-Fix:
Not available
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
15.10.2014
01.02.2016
01.02.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.5 FixList