SQL1531N Error for DB2 Connector

When trying to configure a DB2 connection, the following error message appears:

SQL1531N The connection failed because the name specified with the DSN connection string keyword could not be found in either the db2dsdriver.cfg configuration file or the db2.cli.ini configuration file. Data source name specified in the connection string: <data source name>



Environment:

• Qlik Sense Enterprise - any version
• Qlik Sense Desktop - any version

 

Configuration issue with the IBM DB2 driver. If additional assistance is required, please contact IBM for support.

This is not a Qlik Sense configuration issue. It is a configuration issue with the driver itself. This article offers guidance per the IBM Support site. If additional assistance is required, please contact IBM for support.
 

Explanation

The db2dsdriver.cfg configuration file contains database directory information and client configuration parameters for use by some IBM data server clients and drivers.

The CLI/ODBC initialization file (db2cli.ini) contains various keywords and values that can be used to configure the behavior of CLI and the applications using CLI.

This message is returned when a data source name is specified in a connection string with the "DSN" connection keyword but the specified data source name cannot be found in either of the following locations:

• Specified with the "dsn alias" configuration keyword in the db2dsdriver.cfg configuration file
• Specified as a section header in the db2cli.ini configuration file

User response

1. Add the specified data source name to the db2dsdriver.cfg configuration file or the db2cli.ini configuration file.
2. Stop and restart the application process for the new configuration settings to take effect.
3. Resubmit the connection request to the specified data source name.

Source: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.messages.sql.doc/com.ibm.db2.luw.messages.sql.doc-gentopic5.html#sql1531n

Note: Qlik does NOT support the configuration or implementation of non-Qlik software.