DB2 - Problem description
| Problem IC79229 | Status: Closed |
SQL1402C OR WINDOWS ERROR MESSAGE IS RETURNED WHEN THE MICROSOFT VISUAL C++ 2008 RUNTIME LIBRARIES ARE NOT INSTALLED. | |
| product: | |
DB2 CONNECT / DB2CONNCT / 970 - DB2 | |
| Problem description: | |
In DB2 Version 9.7 Fix Pack 5, IBM Data Server Driver for ODBC
and CLI is dependent on the Microsoft Visual C++ 2008 Runtime
libraries. On most Windows machines, these libraries are
already installed in Side-by-Side assemblies. If these libraries
are not installed and DB2 tries to load them, you will get a
Windows error message stating "The program can't start because
MSVC90.dll is missing from your computer" or from DB2 the
SQL1402C error message. Also, you will see a similar message in
the DB2 diagnostic log:
2011-10-05-23.58.08.714000-240 I1550F665 LEVEL: Error
(OS)
PID : 3312 TID : 2964 PROC :
db2bp.exe
INSTANCE: DB2 NODE : 000
EDUID : 2964
FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:30
MESSAGE : ECF=0x90000007=-1879048185=ECF_UNKNOWN
Unknown
CALLED : OS, -, LoadLibrary
OSERR : 14001 "The application has failed to start because its
side-by-side configuration is incorrect.
Please see the application event log or use the command-line
sxstrace.exe tool for more detail."
DATA #1 : String, 35 bytes
C:\SQLLIB\bin\icc64\gsk8iccs_64.dll
DATA #2 : Hex integer, 4 bytes
0x00000000 | |
| Problem Summary: | |
| Local Fix: | |
Verify that you have the libraries installed in Side-by-Side by searching in the %SYSTEMROOT%\WinSxS folder. Run the following command to search for the libraries: dir /b %SYSTEMROOT%\WinSxS\*VC90.CRT* | find "9.0.21022.8" If the libraries are installed, you will see the following libraries corresponding to system specifications: A) For 32-bit operating systems: x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.21022.8_x-ww_d08d037 5 B) For 64-bit operating systems: amd64_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.21022.8_x-ww_0296e 955 If the libraries are not installed, obtain them from the "Microsoft Visual C++ 2008 Redistributable Package": Microsoft Visual C++ 2008 Redistributable Package (x86) http://www.microsoft.com/download/en/details.aspx?id=29 Microsoft Visual C++ 2008 Redistributable Package (x64) http://www.microsoft.com/download/en/details.aspx?id=15336 DB2 requires C-runtime libraries Version 9.0.21022.8. If your application is 32-bit, install the 32-bit libraries, and if your application is 64-bit, install the 64-bit libraries. | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
| Solution | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 14.10.2011 13.02.2012 13.02.2012 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.5 |
|