DB2 FOR LUW / DB2FORLUW / 970 - DB2

When the database configuration parameter auto_reval is set to 
DISABLED and you run "db2updv97 -a" it updates the DEFINER 
column to 'SYSIBM' in the system catalog table 
SYSIBM.SYSROUTINES for any stored procedure that uses the 
UTL_FILE module. 
 
Consequently, you might get error SQL0727N with system action 
type "5" and SQLCODE "-551" when you call that stored procedure. 
 
The error message is like this: 
 
SQL0727N  An error occurred during implicit system action type 
"5". 
Information returned for the error includes SQLCODE "-551", 
SQLSTATE "42501" and message tokens .........|EXECUTE|.......". 
SQLSTATE=56098 
 
Note that if you upgrade a database from Version 9.5 or earlier, 
the database configuration parameter auto_reval is set to 
DISABLED.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of DB2 for Linux, UNIX and Windows                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* .                                                            * 
****************************************************************

As a workaround you can drop the stored procedure and create it 
again.

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 was first fixed in Version 9.7 Fix Pack 6. 
At a minimum, this fix should be applied on the database server.

As a workaround you can drop the stored procedure and create it 
again.

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

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

13.12.2011
12.06.2012
12.06.2012

9.7.FP6