DB2 FOR LUW / DB2FORLUW / 950 - DB2

A query which uses an OLAP function in the WHEN clause of a CASE 
expression 
 
eg. select ... ( case when ... <OLAP function> end from <table1> 
)  from <table2> 
 
may be rewritten internally by the query compiler to push down 
the OLAP function into a predicate. 
This should result in error SQL0120N, but currently this is not 
intercepted and leads to an unstable 
internal representation of the query. 
 
This can lead to problems of several symptoms. 
 
e.g. A Segmentation violation with the following stack : 
 
-------Frame------ ------Function + Offset------ 
0x090000000D0F0414 op__18sqlnn_xiiphyparentFv@glue1AE + 0x0 
0x090000000D11B524 drop__9sqlnq_qtbFP13sqlnq_memPool + 0xC 
0x090000000E2D92A8 box_drop_ts__9sqlnq_qtbFiN21 + 0x998 
0x090000000D5E8E58 box_drop__9sqlnq_qtbFiT1 + 0x44 
0x090000000EBCBC64 box_drop__9sqlnq_qtbFiT1@glueD1E + 0x78 
0x090000000D3CE180 
drop_dependent_counting_quns__9sqlnq_pidFP13sqlnq_memPool + 0x80 
0x090000000D0FE85C destroy_ptree__9sqlnq_pidFP3loci + 0xF0 
0x090000000FBFD258 
sqlnr_selbox_merge__FP9sqlnq_qtbP9sqlnq_qunT1Pii + 0xDA8 
0x090000000FC48324 
sqlnr_sel_mrg_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x44 
0x090000000DEE1B68 
sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres 
s@AF494_280 
+ 0x170 
0x090000000DEBFB54 
sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres 
s 
+ 0x44 
0x090000000DEBF978 
sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass + 
0xBC 
... 
 
or SQL0901 error : 
 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "Build S_X 
OP : Invalid 
Opcode 0 found, ref_arity 2, sqlng_pid ID is 94".)

certain types of yet unsupported queries may lead to 
aninstance abend. This apar will change this behaviour so 
thaterror SQL0120N will be returned instead.

DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

This problem has first been fixed in V9.5 Fix Pack 9

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC77942 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

06.09.2010
08.03.2012
08.03.2012

9.5.,
9.5.FP9