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

QUERY HANG WHEN SELECTING LARGE OBJECT COLUMNS FROM A TABLE FUNCTION ON DPF

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Given a table function that is defined with the ALLOW PARALLEL 
attribute on DPF that has an output column that is a large 
object, if a select is run against that table function and the 
large object column is included more than once in the select 
list, then a logic problem may occur in the lob materialization 
process that could lead to an infinite hang. 
 
If a trace is taken during the hang, it would show the following 
loop: 
 
13          sqlriglf exit 
14          sqlriglf entry [eduid 3086 eduname db2agent] 
15          | sqldFetchLFD entry [eduid 3086 eduname db2agent] 
16          | sqldFetchLFD data [probe 0] 
17          | sqldFetchLFD data [probe 1] 
18          | | sqldFixExistingTCB entry [eduid 3086 eduname 
db2agent] 
19          | | sqldFixExistingTCB exit 
20          | | sqldx_lob_read entry [eduid 3086 eduname 
db2agent] 
21          | | sqldx_lob_read exit 
22          | sqldFetchLFD data [probe 1000] 
23          | sqldFetchLFD exit 
24          sqlriglf exit 
25          sqlriglf entry [eduid 3086 eduname db2agent] 
 
 
If a stack is collected using db2pd tool against the coordinator 
agent during the hang, the resulting stack traceback file would 
show a codepath like this: 
 
_Z18sqldFixExistingTCBP8sqeAgentP16sqeLocalDatabaseP9SQLP_LSN8ii 
iiPP8SQLD_TCB 
  _Z12sqldFetchLFDP8sqeAgentP9sqllf_lseiiPiPc 
  _Z8sqlriglfP8sqlrr_cbP9sqllf_lseiPiPh 
  _Z8sqlrimsoP8sqlrr_cbP9sqllf_csoPhPjjisPPvi 
  _Z23sqlriWriteCsoIntoBufferP8sqlrr_cbP9sqllf_csolPPvlPhPmPl 
 
_Z34sqljsDrdaAsCBPutLongDataQueryCheckP14db2UCinterfaceP9sqllf_c 
soPmllPPv 
 
_Z34sqlriPutLobLongDatalinksQueryCheckP14db2UCinterfacelP10sqlz_ 
valueP7DDValuelPl 
  _Z14sqlribnoCbDrdaP14db2UCinterface 
  _Z8sqlribnoP8sqlrr_cb 
  _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm 
  _Z11sqlrr_fetchP14db2UCinterfaceP15db2UCCursorInfo 
  _Z16sqljs_ddm_cntqryP14db2UCinterfaceP13sqljDDMObject 
 
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U 
Cinterface 
  _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* System running DB2 v10.50 FP2 or lower                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v10.50 FP3 or higher                          * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.08.2013
03.04.2014
03.04.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.3 FixList
10.5.0.3 FixList