DB2 CONNECT / DB2CONNCT / B50 - DB2

The db2dsdcfgfill command reads in the local database directory
information to populate or update the db2dsdriver.cfg
configuration file.

This file is not getting created from db2 version v11.5.5



The problem is easily reproducible. Steps to reproduce:

1) Create any database:

db2 create database sample



2) The contents of the db directory are:

$ db2 list db directory

System Database Directory


Number of entries in the directory = 1

Database 1 entry:
Database alias = SAMPLE
Database name = SAMPLE
Local database directory = /home/db2inst1
Database release level = 15.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =


Command used to reproduce the issue:

Run the db2dsdcfgfill command e.g. using  instance named db2

db2dsdcfgfill -i db2

Failure case:
SQL0000W Statement processing was successful

and the command execution does not create the db2dsdriver.cfg
file, and display the above warning message.


Success case:
the output for ideal Successful case is:
SQL1535I The db2dsdcfgfill utility successfully created the
db2dsdriver.cfg configuration file.



db2 trace snippet for failure case

180 | db2dsdcfgfill::loadDcsDir exit [rc = 0x9000001A
=-1879048166]
181 | CLI_utlGetCfgPath entry
182 | CLI_utlGetCfgPath data [probe 10]
183 | CLI_utlGetCfgPath exit
184 | rccConfig::getInstance entry
185 | rccConfig::getInstance data [probe 31]
186 | rccConfig::getInstance data [probe 35]
187 | rccConfig::getInstance exit
188 db2dsdcfgfill::main error [probe 110]

****************************************************************
* USERS AFFECTED:                                              *
* db2dsdcfgfill users                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Either use workaround mentioned in Local fix section or move *
* to Db2 v11.5.7.0                                             *
****************************************************************

Follow any of the  below workarounds

1) Manually create db2dsdriver.cfg

2) Install or use earlier version of Db2 dsdriver or Db2 client
earlier to v11.5.,5 to create db2dsdriver.cfg file via
db2dsdcfgfill command

3) Use "db2cli writecfg" option

for example:

db2cli writecfg add -database SAMPDB -host hostname -port 50000
db2cli writecfg add -dsn alias -database SAMPDB -host hostname
-port 50000


For a connection with SSL:
db2cli writecfg add -database SAMPDB -host hostname -port 50001
-parameter "SecurityTransportMode=SSL"
db2cli writecfg add -dsn alias -database SAMPDB -host hostname
-port 50001

****************************************************************
* USERS AFFECTED:                                              *
* db2dsdcfgfill users                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Either use workaround mentioned in Local fix section or move *
* to Db2 v11.5.7.0                                             *
****************************************************************

First fixed in db2 v11.5.7.0

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

19.08.2021
30.11.2021
11.05.2022