Fixes are available
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:
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