IBM Support

IC73117: SQL0471N RETURNED FROM THE STORED PROCEDURE UTL_DIR.CREATE_DIREC TORY AFTER MIGRATING DATABASE FROM 32-BIT TO 64-BIT INSTANCE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • 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
    

Local fix

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

Problem summary

  • ****************************************************************
    * 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.                            *
    ****************************************************************
    

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IC73117

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-12-08

  • Closed date

    2011-04-28

  • Last modified date

    2011-04-28

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC73351

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP

  • R970 PSN

       UP

  • R980 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC73117

Modified date: 28 April 2011