Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC79061 Status: Closed

SQL0471N RETURNED FROM THE STORED PROCEDURE UTL_MAIL,UTL_FILE AFTER
MIGRATING DATABASE FROM 32-BIT TO 64-BIT INSTANCE

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
After migrating a database from 32 to 64-bit instance, that uses 
as an example a function invoking UTL_FILE.IS_OPEN, the 
following error might be encountered: 
 
SQL0471N  Invocation of routine "SYSIBMADM.UTL_FILE.IS_OPEN" 
 
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 
 
This APAR modifies additional system stored procedures below 
which were not covered in IC73117 
 
UTL_MAIL.SEND 
UTL_FILE.FILE_TYPE 
UTL_FILE.FOPEN 
UTL_FILE.IS_OPEN 
UTL_FILE.GET_LINE 
UTL_FILE.FCLOSE
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See ERROR DESCRIPTION.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7 Fixpack 6.                                   * 
****************************************************************
Local Fix:
Upgraded to v9.7 Fixpack 6 containing updated stored procedure 
definitions and run "db2updv97 -d <database_name> -a" to 
recreate these procedures."
available fix packs:
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

Solution
This is a server side fix.  First fixed in v9.7 Fixpack 6
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
04.10.2011
11.06.2012
11.06.2012
Problem solved at the following versions (IBM BugInfos)
9.7.FP6
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.6 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.