DB2 FOR LUW / DB2FORLUW / 950 - DB2

The customer installed the Data Server Driver Package V95 FP4. 
When attemp the table link operation from MS Access using file 
data source, it fails in SYSTEM RESERVED ERROR (-7778).  It can 
get table list successfully when use the user data source or 
system data source. 
 
CLI trace shows the following error at the connect attempt.. 
 
SQLDriverConnectW( hDbc=0:1, hwnd=208:654, 
szConnStrIn="DRIVER={IBM DB2 ODBC DRIVER - 
IBMDBCL1};UID=Administrator;PROTOCOL=TCPIP;HOSTNAME=192.168.107. 
162;PORT=50000;DATABASE=sample;FILEDSN=C:\Program 
Files\Common Files\ODBC\Data Sources\Psample.dsn;", 
cbConnStrIn=193, szConnStrOut=&058690d0, cbConnStrOutMax=513, 
pcbConnStrOut=&0013c72c, fDriverCompletion=SQL_DRIVER_COMPLETE ) 
    ---> Time elapsed - +1.930000E-004 seconds 
( Connection Dialog Message="Dialog Box Displayed", PWD Length=0 
) 
( Connection Dialog Message="A system error has occurred loading 
db2clir.dll", Msg Number=2, Msg Text="WARNING! Could not 
retrieve message text" ) 
( Connection Dialog Message="A system error occurred making a 
system call to DialogBoxParam()", Msg Number=2, Msg 
Text="WARNING! Could not retrieve message text" ) 
 
 
 
In the DSDriver ALL_LANG package, db2clir.dll and db2odbcr.dll 
only in "\msg\en_US" folder. The other language folder does not 
contain these two dll's.  For DS Driver package all language 
should have those dll's because DS Driver supports all locale. 
Because of lacking db2clir.dll, the dialog box for password 
prompt can not be called succsessfully and results in -7778 
error later.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Data Server Driver Package user                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When attempt the table link operation from MS Access using   * 
* ODBC file data source, it fails in SYSTEM RESERVED ERROR     * 
* (-7778).                                                     * 
*                                                              * 
* In the DSDriver ALL_LANG package, db2clir.dll and            * 
* db2odbcr.dll exist only in "\msg\en_US" folder. The other    * 
* language folder does not contain these two dll's.  For DS    * 
* Driver package all language should have those dll's because  * 
* DS Driver supports all locale.                               * 
* Because of lacking db2clir.dll, the dialog box for password  * 
* prompt can not be called succesessfully and results in -7778 * 
* error later.                                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
****************************************************************

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
 

The problem was first fixed by Version 9.5 FP6

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC65768 
follow-up : 

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

13.01.2010
14.05.2010
16.12.2010

9.5.FP6