home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 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

DB2 - Problem description

Problem IT11230 Status: Closed

INSTANCE CAN TRAP IN SQLNG_PREPARE_SUBQ_OPERATION WHEN SQL USING NOT EXISTS
CLAUSE

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
Certain SQL with NOT EXISTS clause can cause the engine to trap 
or cause a SQL901N error. 
 
Example stack output might be : 
 
000007FED210CCB8 offset: 0000000000000118 in 
<sqlng_prepare_SUBQ_operation> 
000007FED20219C3 offset: 0000000000000323 in 
<sqlng_build_SBQR_op> 
000007FED210BBF6 offset: 0000000000001CA6 in 
<sqlng_process_parse_tree_node> 
000007FED2109C1C offset: 00000000000000FC in 
<sqlng_process_BF_node> 
000007FED2108CF8 offset: 0000000000000318 in 
<sqlng_walk_BF_chain> 
000007FED20A8086 offset: 00000000000001B6 in 
<sqlng_build_thread> 
000007FED2024863 offset: 00000000000017F3 in 
<sqlng_build_CASE_op> 
000007FED210BBC7 offset: 0000000000001C77 in 
<sqlng_process_parse_tree_node> 
000007FED2109C1C offset: 00000000000000FC in 
<sqlng_process_BF_node> 
000007FED211378F offset: 000000000000015F in 
<sqlngScalarExpressionBuilder::buildExpression> 
000007FED2112ADF offset: 000000000000003F in 
<sqlngExpressionBuilder::buildExpression> 
000007FED210D238 offset: 0000000000000148 in 
<sqlng_walk_EXPR_chain> 
000007FED20A8D52 offset: 0000000000000E82 in 
<sqlng_build_thread> 
000007FED203B071 offset: 0000000000000441 in 
<sqlng_process_mate_op> 
000007FED1FE4560 offset: 00000000000000C0 in 
<sqlngProcessLolepop> 
000007FED203A529 offset: 00000000000001E9 in 
<sqlng_process_pipe_op> 
000007FED1FE4560 offset: 00000000000000C0 in 
<sqlngProcessLolepop> 
000007FED2069D8E offset: 00000000000002DE in 
<sqlng_process_return_op> 
000007FED1FE4560 offset: 00000000000000C0 in 
<sqlngProcessLolepop> 
000007FED20A8053 offset: 0000000000000183 in 
<sqlng_build_thread> 
000007FED1FE5DE4 offset: 0000000000001664 in <sqlng_main> 
 
000007FED2145E52 offset: 0000000000001402 in <sqlnn_cmpl> 
 
000007FED2144A3C offset: 000000000000003C in <sqlnn_cmpl> 
 
000007FED3542F86 offset: 00000000000002D6 in <sqlrr_cmpl>
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v10.5 Fixpack 7 or Later.                 * 
****************************************************************
Local Fix:
Solution
First Fixed in DB2 LUW v10.5 Fixpack 7.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
15.09.2015
21.01.2016
21.01.2016
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.7 FixList