UIM db2 probe fails to connect to new database
search cancel

UIM db2 probe fails to connect to new database

book

Article ID: 98311

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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