|
Problem IC81709
|
Status: Closed |
AN IN PREDICATE WITH ALL ARGUMENTS BEING CONSTANTS TOGETHER WITH AN EQUALITY PREDICATE OF THE SAME COLUMN MAY RETURN AN ERROR |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DB2 may return an internal error SQL0901N or in some cases, the
DB2 instance suspended with SQL1224N in a query with IN
predicate (from the original query or internally generated) with
constants and an equality predicate on the same
column as the example below:
<col> IN (<constant1>, <constant2>, ...)
AND
<col> = <constant1>
Most of the cases, the two predicates are optimized in DB2 to a
more optimal form. In some complex scenarios where the two
predicates are not optimized, it can result in SQL0901N error.
This problem first occurs in DB2 version 9.7 Fix Pack 5 with the
Query Optimization Class 5.
If the DB2 instance is suspended (crashed) with SQL1224 the
stack from the trap file may be similar to one of the following
stacks. The DB2 instance crash occurs more frequently on the
Linux and Windows platforms.
sqlno_dam_required
sqlno_crule_access_root
qlno_crule_access
sqlno_crule_in2join_access
sqlno_plan_end_opr
sqlno_call_sf
sqlno_each_opr
OR
<sqlno_crule_access_root>
<sqlno_crule_access>
<sqlno_crule_in2join_access>
<sqlno_plan_end_opr>
<sqlno_each_opr>
<sqlno_walk_qun>
OR
<sqlno_get_best_plan>
<sqlno_crule_in2join_access>
<sqlno_plan_end_opr>
<sqlno_each_opr>
<sqlno_walk_qun> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All DB2 users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 6 or later *
**************************************************************** |
| Local Fix: |
Use the query optimization to any classes except 5 to avoid this
problem. |
| available fix packs: |
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem fixed starting DB2 Version 9.7 Fix Pack 6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.02.2012
27.06.2012
24.09.2015 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
