DB2 FOR LUW / DB2FORLUW / A10 - DB2

DB2 will terminate abnormally during explain of a CALL statement 
that satisfies all of the following conditions: 
 
    * The routine being called is an SQL procedure; 
    * The procedure contains one or more cursor declarations; 
    * The procedure has been previously invalidated, and has not 
been revalidated since. 
 
DB2 will also terminate abnormally when a query is being 
explained, and the query contains a reference to at least one 
compiled SQL function that satisfies the following conditions: 
 
    * The function contains one or more cursor declarations; 
    * The function has been previously invalidated, and has not 
been revalidated since.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to v10.1 Fix Pack 1                                   * 
****************************************************************

As a workaround, you can force revalidation of procedures or 
functions before performing the activity that does the explain. 
The easiest way to do this is using the 
ADMIN_REVALIDATE_DB_OBJECTS procedure; e.g., 
 
db2 "connect to mydb" 
db2 "call sysproc.admin_revalidate_db_objects('PROCEDURE', NULL, 
NULL)" 
db2 "call sysproc.admin_revalidate_db_objects('MODULE', NULL, 
NULL)" 
db2 "call sysproc.admin_revalidate_db_objects('FUNCTION', NULL, 
NULL)" 
 
which will revalidate all procedures, module routines, and 
functions in the connected database.

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
 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
 

Fixed in v10.1 Fix Pack 1

keiner bekannt / siehe Local-Fix

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

14.06.2012
02.04.2013
02.04.2013