DB2 CONNECT / DB2CONNCT / A50 - DB2

ODBC/CLI applications on Windows throws SQL1109N error while 
connecting database server over SSL. The same issue is found 
when we try to connect to db using Excel or ODC file. The issue 
discovered when Excel tried to connect to DASHDB using default 
SSL Certificate. 
The connection fails because, CLI driver is trying to create 
default keydb to store SSL certificate, under "Program Files\IBM 
DATA SERVER DRIVER\cfg" folder and user do not have 
administrative privilege to create default keydb under this 
directory. 
The issue is with instance less clients only as instance based 
DB2 clients create such default keydb under ProgramData and not 
under Program Files. 
If user already has administrative privilege or write permission 
for <install_dir>\cfg folder, this issue does not occur.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using instance less clients on Windows for SSL         * 
* connection and do not have write permission for <insall>\cfg * 
* folder.                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.5 FP7 or later releases.                   * 
****************************************************************

Local fix is: run the application as administrator or give write 
permission to the local user for <install_dir>\cfg folder. You 
can try below steps to run the application: 
1. Right click on cmd.exe and run as Administrator, give 
administrator password. Now run application from this command 
prompt. 
2. Right click on excel.exe and run as Administrator. 
File->Open-> select *.odc file. 
3. Right click on C:\Program Files\IBM\IBM DATA SERVER 
DRIVER\cfg folder-> Properties->Go to Security tab->Select Users 
-> Click on Edit Button to change permission->If prompt for 
administrator passwd, give passwd->Select Users-> Check the 
Allow Full Control checkbox->OK ->OK. Now double click on *.odc.

DB2 10.5 FP7  contains fix for this issue. After the fix, 
CLI/ODBC applications and Excel can connect to server using 
dsdriver over SSL.

Run the application as administrator or give write permission to 
the local user for <install_dir>\cfg folder.

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

28.04.2015
14.01.2016
14.01.2016