The UIM db2 probe has been working fine with existing databases. A new database connection was added and for this one the probe fails to connect. UIM Version - 8.51, db2 Probe Version - 4.11
In the probe configure GUI when trying the Test Connection it fails. popup error shows: conf_db2.exe Connection test to instance noe db2pgf failed with: [IBM]]CLI Driver] SQL1013N The database alias name or database name "PGF" could not be found. SQLSTATE=42705
db2.log has: Jun 12 15:31:20:815 [73708] db2: (Connect) - Profile:test connection profile, connecting to database XXX, using connection test connection, user: xxxxxx, connected: No Jun 12 15:31:20:815 [73708] db2: Error code for SQLAllocHandle : 0 Jun 12 15:31:20:817 [73708] db2: (Connect) - Error SQLConnect -1 Jun 12 15:31:20:817 [73708] db2: (Connect) - [IBM][CLI Driver] SQL1013N The database alias name or database name "XXX" could not be found. SQLSTATE=42705
Environment
Release:
Component:
Resolution
As per the IBM knowledge documents the resolution requires correcting the configuration at the at the database.
Additional Information
Testing the connection between the DB2 client and server https://www.ibm.com/support/knowledgecenter/en/SSFUEU_7.0.0/com.ibm.swg.ba.cognos.Installation_Guide_WebSphere.7.0.0.doc/t_camphor_catalogingtheopenpagesdatabaseinstance.html
Testing the Connectivity of the DB2 Client https://www.ibm.com/support/knowledgecenter/en/SSAT72/com.ibm.help.empinstall_configuring.doc/Reporting_Configurations/R_TestingDB2ClientConnectivity.html
The error "SQL1013N The database alias name or database name "PGF" could not be found. SQLSTATE=42705" is the result of the database side configuration.
For guidance see: SQL1013N on db2 connect to <dbname> http://www-01.ibm.com/support/docview.wss?uid=swg21699086
Solved - SQL1013N The Database Alias Name Or Database Name could not be found. SQLSTATE=42705 https://www.youtube.com/watch?v=RLoOWvBhv9Q
IY86277: SQL1013N THE DATABASE ALIAS NAME OR DATABASE NAME COULD NOT BE FOUND. SQLSTATE=42705 http://www-01.ibm.com/support/docview.wss?uid=swg1IY86277