IBM Support

JR32902: MIGRATION STEP REMOVING ROUTINE FROM SQLLIB/FUNCTIONS DIRECTORY,RESULTING IN SQL0444N WHEN THIS ROUTINES ARE CALLED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When migrating from DB2 LUW V9.1, V9.5 to V9.7, any external
    routine libraries placed under <DB2DIR>/function directory will
    be removed. The <DB2DIR> is the DB2 install path. This will
    result in SQL0444 error after the migration, when any related
    routines are invoked under the newly updated DB2 instance.
    the migration is completed.
    
    
    User affected:
    Any user or applications that uses non-DB2 shipped external
    routines.
    

Local fix

  • If the external routine library is still available under a
    different directory after the migration, add that path to the
    Windows system path, and restart DB2.   When doing this one must
    make sure that the search sequence indicated by the PATH
    variable agrees with is how routine libraries are intended
    resolved.
    
    
    Alternatively, copy all the non-IBM libraries from
    <DB2DIR>/function before the migration, and add them back after
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Any user or applications that uses non-DB2 shipped external  *
    *                                                              *
    * routines.                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When migrating from DB2 LUW V9.1, V9.5 to V9.7, any external *
    *                                                              *
    * routine libraries placed under <DB2DIR>/function directory   *
    * will                                                         *
    * be removed. The <DB2DIR> is the DB2 install path. This will  *
    *                                                              *
    * result in SQL0444 error after the migration, when any        *
    * related                                                      *
    * routines are invoked under the newly updated DB2 instance.   *
    *                                                              *
    * the migration is completed.                                  *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * User affected:                                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v9.5 fixpack 5                                    *
    ****************************************************************
    

Problem conclusion

  • Issue fixed in v9.5 fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32902

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-05-06

  • Closed date

    2010-02-17

  • Last modified date

    2010-02-17

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

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

    JR32917

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 February 2010