Latest versionsfixlist
11.1.0.6 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC75399 Status: Closed

DB2 MAY CRASH WITH SQL1224N WHILE PROCESSING A QUERY WITH A LARGE NUMBER OF
"OR" PREDICATES

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
DB2 may crash with SQL1224N while processing a query with a 
large number of "OR" predicates, eg. 4000 "OR" predicates. 
 
The stack trace will look something like: 
 
disconnect_tree 
disconnect_ptree 
destroy_ptree 
sqlnr_trans_pid 
... (repeats many times) 
sqlnr_match_prd 
sqlnr_subsume_prds_sel_sel 
sqlnr_subsume_prds 
sqlnr_subsume_match 
sqlnr_compute_matchinfo 
sqlnr_optprep 
sqlnr_optprep_action 
sqlnr_comp...
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2 may crash with SQL1224N while processing a query with a  * 
*                                                              * 
* large number of "OR" predicates, eg. 4000 "OR" predicates.   * 
*                                                              * 
*                                                              * 
*                                                              * 
* The stack trace will look something like:                    * 
*                                                              * 
*                                                              * 
*                                                              * 
* disconnect_tree                                              * 
*                                                              * 
* disconnect_ptree                                             * 
*                                                              * 
* destroy_ptree                                                * 
*                                                              * 
* sqlnr_trans_pid                                              * 
*                                                              * 
* ... (repeats many times)                                     * 
*                                                              * 
* sqlnr_match_prd                                              * 
*                                                              * 
* sqlnr_subsume_prds_sel_sel                                   * 
*                                                              * 
* sqlnr_subsume_prds                                           * 
*                                                              * 
* sqlnr_subsume_match                                          * 
*                                                              * 
* sqlnr_compute_matchinfo                                      * 
*                                                              * 
* sqlnr_optprep                                                * 
*                                                              * 
* sqlnr_optprep_action                                         * 
*                                                              * 
* sqlnr_comp...                                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 9.5 FP8 or later.                                 * 
****************************************************************
Local Fix:
A workaround is to increase AGENT_STACK_SZ DBM configuration 
parameter.
available fix packs:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
The sqlnr_trans_pid function has been made non-recursive. 
First fixed in 9.5 FP8.
Workaround
A workaround is to increase AGENT_STACK_SZ DBM configuration 
parameter.
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC75582 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
29.03.2011
11.07.2011
11.07.2011
Problem solved at the following versions (IBM BugInfos)
9.5.FP8
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.8 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.