DB2 FOR LUW / DB2FORLUW / 970 - 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 database server to V9.7 Fix Pack 7               * 
****************************************************************

workaround : do not use REOPT ALWAYS.

DB2 Version 9.7 Fix Pack 7 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 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

This problem has first been fixed in DB2 V9.7 Fix Pack 7

keiner bekannt / siehe Local-Fix

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

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

11.04.2012
06.05.2013
06.05.2013

9.7.FP7