IBM Support

JR32917: 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

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

Problem conclusion

  • Fix included in v9.5 , v9.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32917

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-05-07

  • Closed date

    2009-10-08

  • Last modified date

    2009-10-08

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

    JR32902

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

    IC63357 IC63358 IC63361

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021