DB2 FOR LUW / DB2FORLUW / 970 - DB2

A query from an XMLTABLE is supposed to fail with SQL16061 if 
there's an invalid casting.  However, the entire transaction was 
rolled back instead. 
 
Here is an example of such query: 
 
select max(u."mswt") as max1 from 
TABLE(MON_GET_WORKLOAD_DETAILS(CAST(NULL AS BIGINT),-2)) as p, 
XMLTABLE(XMLNAMESPACES(DEFAULT 
'http://www.ibm.com/xmlns/prod/db2/mon'), '$doc/db2_workload' 
PASSING xmlparse (document p.DETAILS) AS "doc" COLUMNS "mswt" 
     BIGINT       PATH 'workload_name') AS U; 
 
Column "mswt" in the above example is of type character, and 
therefore cannot be cast to BIGINT.  The following error should 
have been returned: 
 
SQL16061N  The value "SYSDEFAULTUSERWORKLOAD" cannot be 
constructed as, or 
cast (using an implicit or explicit cast) to the data type 
"xs:long". Error 
QName=err:FORG0001.  SQLSTATE=10608 
 
However, the following  error was returned, and the entire 
transaction was rolled back: 
 
SQL1476N  The current transaction was rolled back because of 
error "-16061". 
SQLSTATE=40506

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See APAR description                                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Users should upgrade to V97 Fp2                              * 
****************************************************************

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

This problem is fixed V97 Fp2

keiner bekannt / siehe Local-Fix

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

17.05.2010
22.06.2010
22.06.2010

9.7.FP2