DB2 FOR LUW / DB2FORLUW / 970 - DB2

A defect in DB2 Version 9.7 Fix Pack 3a can cause an unexpected 
error or server trap when an SQL procedure performs a BULK 
COLLECT operation.  To correct this problem, you must recreate 
the SQL procedure using Version 9.7 Fix Pack 4 or later. 
 
Code was also added in Fix Pack 4 to detect affected SQL 
routines.  When DB2 detects a potentially faulty routine that 
uses BULK COLLECT and was compiled using Fix Pack 3a, DB2 will 
report error -901, which is a severe error code normally 
reserved for unexpected DB2 internal errors.  In this situation, 
however, the error is expected.  The reported error will be 
changed to a less severe -471 error in Version 9.7 Fix Pack 5.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Trying to execute a PL/SQL procedure created in db2 v97fp3a  * 
* with bulk collect operations.                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If a PL/SQL routine with bulk collection operations were     * 
* created in db2 v97fp3a, it would need to be recreated in     * 
* v97fp4 or a later fixpack. A -901 error will be returned by  * 
* db2_v97fp4 if a customer attempts to executes the routine    * 
* without recreating.                                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2_v97fp5 and recreate the routine that          * 
* triggered the -471 error.                                    * 
****************************************************************

Drop and recreate the affected SQL routine, using DB2 Version 
9.7 Fix Pack 4 or later.

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

The error is changed from -901 to a less severe -471 in 
db2_v97fp5. The customer still need to recreate the routine for 
it to execute successfully. The first message token of the -471 
error contains the full qualified routine name.

not known / see Local fix

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

10.08.2011
07.12.2011
07.12.2011