DB2 FOR LUW / DB2FORLUW / 970 - 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:                                              * 
* stored procedure users                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 FP6 or higher                             * 
****************************************************************

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 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 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
 

Problem fixed in DB2 Version 9.7 Fix Pack 6 and subsequent fix 
packs.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC84402 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

14.10.2011
28.06.2012
28.06.2012

9.7.FP6