DB2 FOR LUW / DB2FORLUW / 970 - DB2

Under rare scenarios, DB2 might abend when the following 
conditions are true: 
1) DB2 is running with DB2_COMPATIBILITY_VECTOR=ORA 
2) The query contains one or more LIKE predicates 
3) The query contains a UNION with at least 2 branches. 
4) The column referenced in the LIKE predicate is of datatype 
CHAR/GRAPHIC 
5) The same column is also referenced in the output columns of 
the UNION ALL branches and is a complex expression with a 
resulting datatype of VARCHAR/VARGRAPHIC in at least one branch. 
 
 
You may see the following in the trap file: 
 
<POFDisassembly> 
 _ZNK9sqlnq_pid2opEv + 0x0000 
 
</POFDisassembly> 
<StackTrace> 
-----FUNC-ADDR---- ------FUNCTION + OFFSET------

**************************************************************** 
* USERS AFFECTED:                                              * 
* V9.7                                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Explicitly cast the LIKE predicate column to be of type      * 
* VARCHAR                                                      * 
* or VARGRAPHIC                                                * 
****************************************************************

Explicitly cast the LIKE predicate column to be of type VARCHAR 
or VARGRAPHIC

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

16.03.2015
15.10.2015
15.10.2015