|
Problem IC62591
|
Status: Closed |
A QUERY MAY COMPILE INDEFINITELY IF CERTAIN CONDITIONS ARE SATISFIED. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
In V9.1 a query may compile indefinitely if the following condit
ions are satisfied:
1) There are atleast two UNION ALLs joining indirectly through o
ne or more tables
2) One of the UNION ALL has a correlated column to either the
table or the other UNION ALL.
Force application is not effective in V9.1 while executing in
this function. On ending the db2 instance, the following stack
trace might be observed:
sqlnr_sort_sips_order
sqlnr_sort_sips_order
sqlnr_sips_order
sqlnr_magic_action
sqlnr_comp
sqlnr_seq
sqlnr_rcc
sqlnr_magic_detail_action
sqlnr_comp
sqlnr_seq
sqlnr_rcc
sqlnr_endqtb_action
sqlnr_comp
sqlnr_seq
sqlnr_rcc
sqlnr_start_action
sqlnr_comp
sqlnr_seq
sqlnr_rcc
sqlnr_exe
sqlnn_cmpl |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All customer having UNION ALL views withcorrelated *
* predicates *
****************************************************************
* PROBLEM DESCRIPTION: *
* A QUERY MAY COMPILE INDEFINITELY IF THERE IS A UNION ALLVIEW *
* WITH BRANCHES HAVING CONFLICTING CORRELATED PREDICATES. *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to DB2 Version 9.7 Fix Pack 2 *
**************************************************************** |
| Local Fix: |
A possible work around is SET CURRENT OPTIMIZATION LEVEL to 0
or 1. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 Version 9.7 Fix Pack 2 |
| Workaround |
A possible work around is SET CURRENT OPTIMIZATION LEVEL to 0
or 1. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.08.2009
25.05.2010
25.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.,
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
