Fixes are available
DB2 Version 9.1 Fix Pack 4a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 3 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 4 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 2a - interim special build 2a
DB2 Version 9.1 Fix Pack 1 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 2 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 3a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
APAR status
Closed as program error.
Error description
DB2 9 installed on 32-bit Windows XP / Windows Server 2003 systems that have the MSVCR80.DLL in their system PATH may experience sporadic hangs. If it is indeed this problem, there will be a Windows Application event log entry similar to this recorded: "Application popup: Microsoft Visual C++ Runtime Library : Runtime Error! Program: C:\IBM\SQLLIB\bin\db2syscs.exe R6034 An application has made an attempt to load the C runtime library incorrectly. Please contact the application's support team for more information. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. . Any attempts to interact with DB2 either locally or remotely (e.g. connect, attach, various DB2 utilities, etc.) will result in the command hanging/freezing and the command never returning. The only way to get the command to complete is to switch to the console session of the 32-bit Windows XP/Windows Server 2003 system and clicking OK to close pop up window that appears indicating the Microsoft Visual C++ Runtime Library load failure. . The pop up window only appears and the server only hangs when math-related operations are performed by the server which makes use of the Intel Math library. It's this library that tries and fails to load the manifested MSVCR80.DLL which results in the pop up window. . On some machines where MSVCR80.DLL can be found in the system PATH, this manifested DLL clashes with the other Microsoft C-Runtime DLLs that DB2 relies on and this results in a pop up window (on the console session in the case of Windows Server 2003) that hangs the DB2 server until the OK button is clicked.
Local fix
Although not a particularly practical workaround, renaming/removing the application that put MSVCR80.DLL into the system PATH will effectively resolve this problem.
Problem summary
Users Affected: Windows XP/2003 users. Problem Description: Some DB2 commands might hang if MSVCR80.DLL is found in the PATH
Problem conclusion
First fixed in DB2 Version 9, FixPak 1
Temporary fix
Comments
APAR Information
APAR number
JR25415
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
2006-11-29
Closed date
2006-12-14
Last modified date
2008-10-14
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 UDB ESE WIN
Fixed component ID
5765F4101
Applicable component levels
R910 PSN
UP
Document Information
Modified date:
08 January 2022