|
Problem IT25781
|
Status: Geschlossen |
DB2 MAY ABEND WHEN COMPILING A QUERY CONTAINING A SEMI-JOIN
|
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
DB2 may terminate abnormally when compiling a query that
contains a semi-join. For more information on semi-joins, please
review the following tech note:
http://www-01.ibm.com/support/docview.wss?uid=swg21984292 .
An example stack trace is seen below:
address: 0x00007F0CBBB54850 ; dladdress: 0x00007F0CBBB45000 ;
offset in lib: 0x000000000000F850 ;
sqlno_pred_classifyP13sqlno_globalsP9sqlno_qtbP9sqlno_prd
sqlno_assign_optprdP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq
_prdPi
sqlno_assign_prdP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq_pr
d
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_opr
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_assign_walk_quns_and_ffP13sqlno_globalsP9sqlno_sfbP9sqlnq_
oprP9sqlnq_qun
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_opr
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_assign_walk_quns_and_ffP13sqlno_globalsP9sqlno_sfbP9sqlnq_
oprP9sqlnq_qun
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_opr
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_assign_walk_quns_and_ffP13sqlno_globalsP9sqlno_sfbP9sqlnq_
oprP9sqlnq_qun
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_opr
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_assign_walk_quns_and_ffP13sqlno_globalsP9sqlno_sfbP9sqlnq_
oprP9sqlnq_qun
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_opr
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_assign_walk_quns_and_ffP13sqlno_globalsP9sqlno_sfbP9sqlnq_
oprP9sqlnq_qun
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_opr
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_assign_walk_quns_and_ffP13sqlno_globalsP9sqlno_sfbP9sqlnq_
oprP9sqlnq_qun
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_opr
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_assign_walk_quns_and_ffP13sqlno_globalsP9sqlno_sfbP9sqlnq_
oprP9sqlnq_qun
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_opr
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_top_qtbP13sqlno_globalsP9sqlno_sfbP9sqlnq_qurP9sqlnq_qtb
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_each_qurP13sqlno_globalsP9sqlno_sfbP9sqlnq_qurS4_
sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQLNN_
BOOLEAN
sqlno_scan_qgmP13sqlno_globalsP9sqlno_sfbP9sqlnq_qur
sqlno_prep_phaseP13sqlno_globalsP9sqlnq_qur
sqlno_exeP9sqlnq_qur
sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sqlrr_
cmpl_enviiPP9sqlnq_qur
sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sqlrr_
cmpl_env
sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14SQLP_LOC
K_INFOP16sqlra_cached_varPiS5_Pb
sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idjjPhj
thP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P14SQLP_LOCK_INF
OPP16sqlra_cached_varS8_bSA_Pb
sqlra_get_varP8sqlrr_cbiibPbS1_
sqlrr_prepareP14db2UCinterfaceP16db2UCprepareInfo
sqljs_ddm_prpsqlsttP14db2UCinterfaceP13sqljDDMObject
sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCint
erface
sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb
address: 0x00007F0CAAFB9DBA ; dladdress: 0x00007F0C88EE6000 ;
offset in lib: 0x00000000220D3DBA ;<
address: 0x00007F0CAAFBC70A ; dladdress: 0x00007F0C88EE6000 ;
offset in lib: 0x00000000220D670A ;<
address: 0x00007F0CAAFB6EB7 ; dladdress: 0x00007F0C88EE6000 ;
offset in lib: 0x00000000220D0EB7 ;<
sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T
sqeAgent6RunEDUEv
sqzEDUObj9EDUDriverEv
sqlzRunEDUPcj
sqloEDUEntry
address: 0x00007F0CBBB4C806 ; dladdress: 0x00007F0CBBB45000 ;
offset in lib: 0x0000000000007806 ;<
clone |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Will be fixed in next release (v11.1) via APAR IT25838 *
**************************************************************** |
| Local-Fix: |
Disable the semi-join rewrite for the instance by setting the
DB2COMPOPT registry variable to NOOJSJ or for a specific SQL
query via an optimizer guideline. |
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger :
Nachfolger : IT25838 |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 23.07.2018
28.02.2020
28.02.2020 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
