DB2 FOR LUW / DB2FORLUW / A10 - DB2

An application that invokes an SQL statement operating with 
REOPT ALWAYS enabled, may suffer error SQL0901 with Reason 
string : 
"EXPECTED TEMP TCB" when the SQL statement involves the 
manipulation of XML temporary data. 
 
e.g. 
 
a stored procedure created with  "CALL 
SYSPROC.SET_ROUTINE_OPTS('REOPT ALWAYS')"  run prior to the 
procedure creation and 
code similar to this : 
 
CREATE PROCEDURE proc1 ( IN @inputxml XML ) 
... 
P1 : BEGIN 
 
   select * from XMLTABLE ( 'p ....  PASSING @inputxml as "p" 
....  ) 
 
( syntax not complete and just pasted for illustration ) 
 
... 
 
END P1 
 
Can fail with the error, if the input values ( @inputxml ) come 
from a non-permanent table.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the DB2 server side to V10.1 Fix Pack 2              * 
****************************************************************

workaround : do not use REOPT ALWAYS.

DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

This problem has first been fixed in V10.1 Fix Pack 2

keiner bekannt / siehe Local-Fix

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

04.11.2012
06.05.2013
06.05.2013