DB2 FOR LUW / DB2FORLUW / A50 - DB2

The following error may be seen connecting to a database with 
SERVER_ENCRYPT authentication 
 
db2 connect to db user ******** using ******** 
SQL1042C  An unexpected system error occurred.  SQLSTATE=58004 
 
In the db2diag.log a message similar to the following will also 
be seen: 
 
PID     : 5180                 TID : 3208           PROC : 
db2bp.exe 
INSTANCE: DB2                  NODE : 000 
HOSTNAME: host 
EDUID   : 3208 
FUNCTION: DB2 Common, Cryptography, cryptDynamicLoadGSKitCrypto, 
probe: 
998 
MESSAGE : ECF=0x9000002F=-1879048145=ECF_FILE_DEVICE_UNAVAILABLE 
          The device is unavailable or uncapable of serving the 
request 
DATA #1 : unsigned integer, 4 bytes 
60 
DATA #2 : String, 14 bytes 
gsk8sys_64.dll 
 
As part of the SERVER_ENCRYPT authentication process, DB2 first 
tries to load the GSKit 8 library from the PATH 
environment variable. If the GSKit 8 library is not found, DB2 
tries to load the gskit-crypto library. 
 
This error occurs because starting in Windows 7, the operating 
system returns an error stating 'device not ready' instead of 
'library not found 'when the PATH contains a removable drive 
(such 
as a CD/DVD drive).  This causes DB2 to log the 
ECF_FILE_DEVICE_UNAVAILABLE message when trying to find GSKit 8 
and it does not proceed to try and load gskit-crypto. 
 
The purpose of this APAR is to improve the error message in the 
db2diag.log to also include the text "A possible reason for a 
LoadLibrary failure might be a CD/DVD drive in a middle of the 
PATH. Please consider rearranging the PATH" when logging the 
ECF_FILE_DEVICE_UNAVAILABLE message.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Windows                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.5 Fixpack 4                                * 
****************************************************************

Correct the PATH environment variable to remove the reference to 
the removable drive (such as the CD/DVD drive)

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

First fixed in DB2 10.5 Fixpack 4

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

31.01.2014
09.09.2014
09.09.2014