DB2 FOR LUW / DB2FORLUW / A50 - DB2

DB2 can trap when it compiles a SQL query that has a sub-query 
applied on XMLQUERY(), and the query block that contains the 
sub-query has more than 64 predicates. 
 
The following is an example of the sub-query: 
 
XMLCAST(XMLQUERY(...)   AS CHAR(8)) IN (SELECT X FROM TABLE1) 
 
 
It can generate the stack traces below: 
 
-------------- Stack Trace ------------------------- 
sqlno_copy_plan_map 
copy_plan_args 
sqlno_copy_function_args 
sqlno_copy_plan__FCP13sqlno 
sqlno_crule_save_plans 
sqlno_crule_access 
sqlno_crule_access 
sqlno_find_plan_chain 
sqlno_get_best_plan 
sqlno_crule_nljn_inner 
sqlno_crule_nljn 
sqlno_crule_join_choices 
sqlno_crule_join_order 
sqlno_crule_join_root 
sqlno_crule_join 
sqlno_gen_partitions_for_QTB 
sqlno_plan_end_opr 
sqlno_each_opr 
sqlno_walk_qun 
sqlno_each_opr 
sqlno_top_qtb 
sqlno_each_qur 
sqlno_scan_qgm 
sqlno_planning_scan 
sqlno_planning_phase 
sqlno_exe 
sqlno_exe 
sqlnn_cmpl 
sqlnn_cmpl 
sqlra_compile_var 
sqlra_find_var 
sqlra_get_var 
sqlrr_prepare 
sqljs_ddm_prpsqlstt 
sqljsParseRdbAccessed 
sqljsParse.fdpr.clone.77 
@63@sqljsSqlam 
@63@sqljsDriveRequests 
@63@sqljsDrdaAsInnerDriver 
sqljsDrdaAsDriver 
RunEDU 
EDUDriver 
sqloEDUEntry 
 
-------------- Stack Trace ------------------------- 
pthread_kill 
sqloDumpEDU 
sqle_panic 
sqle_trap 
sqlzAssertFailedValist 
sqlzAssertFailed 
sqlo_md_mcpy 
sqlno_copy_setN 
sqlno_difference_setsN 
sqlno_difference_set 
sqlno_prop_preds 
sqlno_prop_filter 
FILTER__FP13sqlno 
sqlno_crule_xscan 
sqlno_crule_access_root 
sqlno_crule_access 
sqlno_find_plan_chain 
sqlno_get_best_plan 
sqlno_get_best_plan 
sqlno_crule_nljn_inner 
sqlno_crule_nljn 
sqlno_crule_join_choices 
sqlno_crule_join_order 
sqlno_crule_join_root 
sqlno_crule_join 
sqlno_gen_partitions_for_QTB 
sqlno_plan_end_opr 
sqlno_call_sf 
sqlno_each_opr 
sqlno_call_sf 
sqlno_walk_qun 
sqlno_call_sf 
sqlno_each_opr 
sqlno_call_sf 
sqlno_top_qtb 
sqlno_call_sf 
sqlno_each_qur 
sqlno_call_sf 
sqlno_scan_qgm 
sqlno_planning_scan 
sqlno_planning_phase 
sqlno_exe 
sqlnn_cmpl 
sqlnn_cmpl 
sqlra_compile_var 
sqlra_find_var 
sqlra_get_var 
sqlrr_prepare 
sqljs_ddm_prpsqlstt 
sqljsParseRdbAccessed 
sqljsParse 
sqljsSqlam 
sqljsDriveRequests 
sqljsDrdaAsInnerDriver 
sqljsDrdaAsDriver 
RunEDU 
EDUDriver 
sqlzRunEDU 
qloEDUEntry 
 
----------------------------------- 
 
On DB2 9.7FP8 it can generat a FODC application error with the 
stack below, however the DB2 instance doesn't crash. 
 
-------------- Stack Trace ------------------------- 
pthread_kill 
sqloDumpEDU 
sqldDumpContext 
sqldDumpContext 
sqlrr_dump_ffdc 
sqlzeDumpFFDC 
sqlzeSqlCode 
sqlnn_erds 
sqlnn_erds 
sqlno_copy_function_args 
sqlno_copy_plan 
sqlno_copy_plan_map 
copy_plan_args 
sqlno_copy_function_args 
sqlno_copy_plan 
sqlno_crule_save_plans 
sqlno_crule_access 
sqlno_crule_access 
sqlno_find_plan_chain 
sqlno_get_best_plan 
sqlno_crule_nljn_inner 
sqlno_crule_nljn 
sqlno_crule_join_choices 
sqlno_crule_join_order 
sqlno_crule_join_root 
sqlno_crule_join 
sqlno_gen_partitions_for_QTB 
sqlno_plan_end_opr 
sqlno_each_opr 
sqlno_walk_qun 
sqlno_each_opr 
sqlno_top_qtb 
sqlno_each_qur 
sqlno_scan_qgm 
sqlno_planning_scan 
sqlno_planning_phase 
sqlno_exe 
sqlno_exe 
sqlnn_cmpl 
sqlra_compile_var 
sqlra_find_var 
sqlra_get_var 
sqlrr_prepare 
sqljs_ddm_prpsqlstt 
sqljsParseRdbAccessed 
sqljsParse.fdpr.clone.0 
@63@sqljsSqlam 
@63@sqljsDriveRequests 
@63@sqljsDrdaAsInnerDriver 
RunEDU 
EDUDriver 
sqloEDUEntry 
 
----------------------------------- 
 
 
 
There is no workaround.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See problem description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* First Fixed in Version 10.5 Fix Pack 3.                      * 
****************************************************************

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
 

First Fixed in Version 10.5 Fix Pack 3.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

27.08.2013
19.12.2013
19.12.2013