db2 probe fails test connection to DB2 11.1 Server - Database Error
search cancel

db2 probe fails test connection to DB2 11.1 Server - Database Error

book

Article ID: 109876

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

DB2 probe will not test connenction to the DB2 11.1 server with the error :


Connection test to instance node DB2 failed with:[IBM][CLIDriver] SQL1039C An I/O error occurred while accessing the database directory. SQLSTATE=58031
And also db2 probe is not reading the host name and IP properly.

db2: ptNetHostToIp - getaddrinfo failed for (null)

db2: ciGetDeviceIdentifiers - host=DB2, IP=<NULL> [D7502178626FC378991B19AF086B07AF7]
 

Environment

UIM 8.51 and later
DB2 Probe 4.10
DB2 Problem Server 11.1 (Not QA tested)

Cause

DB2 11.1 version is not certified with current version of UIM . DB2 11.1 is not yet tested in our QA environment for certification.

Resolution

This indicates a possible DB2  configuration issue and needs  populating the catalog properly.

The db2 client MUST be configured to access this instances via the catalog before the probe can work. Please engage your DBA for proper setup of the db2 probe for communication to the database.


(OR)


Workaround:-
===========
Supported version did not have a problem. For unsupported DB2 database version please turn the catalog off on the problem DB2 client server and will start monitoring it remotely .

Additional Information

IBM has plenty of docs on this
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.5.0/com.ibm.db2.luw.qb.server.doc/doc/t0007292.html 
https://datageek.blog/2011/04/14/how-to-catalog-a-db2-database/ 
https://dba.stackexchange.com/questions/133176/add-a-db2-catalog-to-a-new-remote-server-and-make-it-work