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

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

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