DB2 FOR LUW / DB2FORLUW / 950 - DB2

Execution of a query may fail with SQL0901N if the following 
conditions are satisfied: 
- Database is Data Partitioning Feature (DPF) enabled 
- Query or a view it references or one of its nested subselects 
contains an expression of COALESCE (or its synonym VALUE) scalar 
function in the output column list 
- A column <col> used in the COALESCE function is also used in a 
equality predicate <col> = <const> where <const> is a constant 
or 
a host variable or a special register. 
 
The SQL0901N error message contains the following text: 
 
SQL0901N The SQL statement failed because of a non-severe system 
error. 
Subsequent SQL statements can be processed. (Reason "probe 030 
in sqlkt_pack_tuple(), msg=cold=NULLABLE zvalue=NONULLS col(".) 
SQLSTATE=58004

**************************************************************** 
* USERS AFFECTED:                                              * 
* db2_v95fp5                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* IN A DPF ENVIRONMENT, QUERY CONTAINING AN OUTPUT             * 
* COALESCE(<COL1>,<COL2>) AND A PREDICATE <COL2>=<CONST> MAY   * 
* FAIL WITH SQL0901N                                           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2_v95fp8                                        * 
****************************************************************

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
 

Fix in db2_v95fp8

keiner bekannt / siehe Local-Fix

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

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

18.11.2010
22.07.2011
22.07.2011