Fixes are available
Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 4 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows
APAR status
Closed as fixed if next.
Error 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
Local fix
NA
Problem summary
**************************************************************** * USERS AFFECTED: * * NA * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.4 * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IT24631
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-04-05
Closed date
2018-12-10
Last modified date
2018-12-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
RB10 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 May 2022