DB2 FOR LUW / DB2FORLUW / 970 - DB2

After migrating a database from 32 to 64-bit instance, that uses 
 
as an example a function invoking UTL_DIR.CREATE_DIRECTORY, the 
following error might be encountered: 
 
SQL0471N  Invocation of routine 
"SYSIBMADM.UTL_DIR.CREATE_DIRECTORY" 
failed due to reason "1".  SQLSTATE=55023 
 
 
More detail on the error provides: 
 
1        The invocation failed because the SQL routine was 
created on a previous release of the product and the DBMS was 
not able to migrate it to the current release. The routine must 
be 
dropped and re-created to become operative again. 
 
 sqlcode: -471 
 
 sqlstate: 55023

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SQL0471N returned from some stored procedures, such as       * 
* UTL_DIR.CREATE_DIRECTORY, after migrating database from      * 
* 32-bit to 64-bit instance. For more details, see ERROR       * 
* DESCRIPTION.                                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7 Fixpack 4 containing updated stored          * 
* procedure definitions, and run "db2updv97 -d <database_name> * 
* -a" to recreate these procedures.                            * 
****************************************************************

Upgrade to v9.7 Fixpack 4 containing updated stored procedure 
definitions, and run 
"db2updv97 -d <database_name> -a" to recreate these procedures.

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

First fixed in v9.7 Fixpack 4. At minimum this fix should be 
applied to the server side.

keiner bekannt / siehe Local-Fix

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

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

08.12.2010
28.04.2011
28.04.2011

9.7.FP4