DB2 - Problem description
Problem IT24630 | Status: Closed |
DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING CORRELATED PREDICATES | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
DB2 may terminate abnormally when compiling a query that contains correlated predicates. An example stack trace for this problem is seen below: sqlno_int_order_equiv_jcols_quns sqlno_int_order_itr_nljn 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_walk_qun sqlno_each_opr sqlno_top_qtb sqlno_each_qur sqlno_scan_qgm sqlno_planning_scan sqlno_planning_phase sqlno_exe sqlnn_cmpl sqlnn_cmpl sqlra_compile_var sqlra_find_var sqlra_statement_concentrator sqlra_get_var sqlrr_prepare sqljs_ddm_prpsqlstt sqljsParseRdbAccessed sqljsParse sqljsSqlam sqljsDriveRequests sqljsDrdaAsInnerDriver sqljsDrdaAsDriver sqeAgent::RunEDU sqlzRunEDU sqloEDUEntry | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * db2_v105fp10 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to 10.5 fp10 * **************************************************************** | |
Local Fix: | |
NA | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : IT24631 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.04.2018 11.07.2018 11.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |