SQL1013N the database alias name or database could not be found SQLSTATE=42705

Product:

Microsoft Windows 2022 server
DB2 driver

Issue:

Can not connect to DB2 server with ODBC, the dbalias is not found.

Solution:

Inside the ODBC program, you need to setup a alias.

This is controlled by the db2cli.ini file.

If you run a bat file to catalog the sql db2 settings this file will end up in your profile folder, e.g. c:\users\yourname

Copy the file to the common folder c:\programdata\ibm\db2\db2copy1\cfg

Search for db2cli.ini to find the folders to use. The db2cli.ini have lines like below:

[db2instance]
DBALIAS=db2instance
UID=donald
DESCRIPTION=db2instance - PROD

Run the setup.exe from inside folder \wib_data_server_client_winx64_v11.1\client\image.

Create a catalog.sql file with the content you need; (you must adjust to your environment)

UNCATALOG NODE db2instance;
CATALOG TCPIP NODE db2instance
REMOTE db2servername.domain.com
SERVER 50000
REMOTE_INSTANCE db2instance
OSTYPE LINUX;

The run a command like this from a bat file:

db2cmd db2setcp ” db2 -tvf C:\install\catalog.sql ”

This will give you the User DSN setup.

You can find the values in the registry, download to a reg file, and edit it to be HKLM as below;

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\db2instance]
"Driver"="C:\\PROGRA~1\\IBM\\SQLLIB\\BIN\\DB2CLIO.DLL"
"Description"="db2instance"

Load this file, and you will get it in System DNS.

Then you need to update the db2cli.ini in the folder c:\programdata\ibm\db2\db2copy1\cfg to get the dbalias.

If it does not work, check the links below.

More information:

Installing and configuring an DB2 ODBC CLI-driver on Windows

CogKnowHow