Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
APAR status
Closed as program error.
Error description
This error only occurs in DB2 Version 9.1 FixPak 5, and can only be encountered when the statement references one or more table partitioned across multiple database partitions. . The DB2 server could unexpectedly terminate with the following call function stack during the compilation of an insert statement: . sqlno_force_sort_after_tq__FCP13sqlno_globalsCP13sqlno_contextC P10sqlno_partT3 + 0xE4 sqlno_crule_glue_plan__FP13sqlno_globalsP13sqlno_contextP19sqln o_plan_operator9sqlno_setP17sqlno_order_classP9sqlno_keyP10sqln o_part13sqlno_sat_reqPP19sqlno_plan_operator + 0x3F0 sqlno_crule_glue_root__FP13sqlno_globalsP13sqlno_contextP14sqln o_planlist9sqlno_setP17sqlno_order_classP9sqlno_keyP10sqlno_par t13sqlno_sat_reqT3 + 0xB8 sqlno_crule_glue__FP13sqlno_globalsP9sqlno_qtbP18sqlno_join_con textP20sqlno_req_properties9sqlno_setP19sqlno_plan_operator + 0x518 sqlno_itr_get_plan__FP13sqlno_globalsP9sqlno_qtbP18sqlno_join_c ontext13SQLNN_BOOLEANP20sqlno_req_propertiesPP19sqlno_plan_oper atorP9sqlno_set + 0x270 next__14sqlno_itr_planFPP19sqlno_plan_operatorP9sqlno_set + 0x278 sqlno_crule_simple_mate__FP13sqlno_globalsP13sqlno_contextP9sql nq_sat9sqlno_setT413SQLNN_BOOLEANP14sqlno_planlistT6 + 0x520 sqlno_crule_mate_root__FP13sqlno_globalsP13sqlno_context9sqlno_ setT3P14sqlno_planlist + 0x4A4 sqlno_crule_mate__FP13sqlno_globalsP9sqlno_qtb + 0x420 sqlno_plan_end_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_opr + 0xC5C <...snip...>
Local fix
Reducing the optimization level may avoid hitting the problem; f or example, . SET CURRENT QUERY OPTIMIZATION 1 <statement text> SET CURRENT QUERY OPTIMIZATION <current dft_query_opt value>
Problem summary
**************************************************************** USERS AFFECTED: All users using the database partitioning feature on DB2 Version 9.1 Fix Pack 5 are vulnerable. **************************************************************** PROBLEM DESCRIPTION: The DB2 server could unexpectedly terminate with the following call function stack during the compilation of an insert statement that references one or more tables hash partitioned across multiple database partitions: . sqlno_force_sort_after_tq__FCP13sqlno_globalsCP13sqlno_contextC P10sqlno_partT3 + 0xE4 sqlno_crule_glue_plan__FP13sqlno_globalsP13sqlno_contextP19sqln o_plan_operator9sqlno_setP17sqlno_order_classP9sqlno_keyP10sqln o_part13sqlno_sat_reqPP19sqlno_plan_operator + 0x3F0 sqlno_crule_glue_root__FP13sqlno_globalsP13sqlno_contextP14sqln o_planlist9sqlno_setP17sqlno_order_classP9sqlno_keyP10sqlno_par t13sqlno_sat_reqT3 + 0xB8 sqlno_crule_glue__FP13sqlno_globalsP9sqlno_qtbP18sqlno_join_con textP20sqlno_req_properties9sqlno_setP19sqlno_plan_operator + 0x518 sqlno_itr_get_plan__FP13sqlno_globalsP9sqlno_qtbP18sqlno_join_c ontext13SQLNN_BOOLEANP20sqlno_req_propertiesPP19sqlno_plan_oper atorP9sqlno_set + 0x270 next__14sqlno_itr_planFPP19sqlno_plan_operatorP9sqlno_set + 0x278 sqlno_crule_simple_mate__FP13sqlno_globalsP13sqlno_contextP9sql nq_sat9sqlno_setT413SQLNN_BOOLEANP14sqlno_planlistT6 + 0x520 sqlno_crule_mate_root__FP13sqlno_globalsP13sqlno_context9sqlno_ setT3P14sqlno_planlist + 0x4A4 sqlno_crule_mate__FP13sqlno_globalsP9sqlno_qtb + 0x420 sqlno_plan_end_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_opr + 0xC5C <...snip...> **************************************************************** RECOMMENDATION: Upgrade to Version 9.1 Fix Pack 6. ****************************************************************
Problem conclusion
The problem was first fixed in Version 9.1 Fix Pack 6.
Temporary fix
see LOCAL FIX
Comments
APAR Information
APAR number
IZ33474
Reported component name
DB2 DPF
Reported component ID
5724N7400
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-09-26
Closed date
2008-11-03
Last modified date
2008-11-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 DPF
Fixed component ID
5724N7400
Applicable component levels
R910 PSN
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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":"910"}]
Document Information
Modified date:
03 October 2021