UIM DB2 probe false alarms: SQL30081N A communication error has been detected

Article Id: 144582
Status: Published
Updated On: 07-02-2020 03:59
Products:
DX Infrastructure Management , NIMSOFT PROBES , DX Infrastructure Management
Issue/Introduction:

My UIM DB2 probe generates unexpected alarms such as:  

"database <databse_name> at instance <darabase_instanc> is offline ([IBM][CLI Driver] SQL30081N  A communication error has been detected. Communication protocol being used: "TCP/IP".  Communication API being used: "SOCKETS"

SQL30081N  A communication error has been detected

 

Cause:

SQL30081N error determines in most of the cases a network issue. 
Please engage your network team to investigate if there is any intermittent communication issues between the monitoring probe and the monitored DB

https://www.ibm.com/support/pages/sql30081n-tcpip-communication-errors 


If at the time the probe generated the alarm you confirm there isn't any communication issue, then it might be that the probe generates this error due to the target DB not being able to respond within the default timeouts configured in the probe.

Environment:

Release : 9.2.0

Component : UIM - DB2

Resolution:

Update timeouts:

connection tab:
- Default connection timeout is 5 > increase at least to 30 seconds (Up to 5 minutes)






- Profiles tab
SQL timeout default is 30 seconds > increase to 60 Seconds.







Additional Information:

db2 (DB2 Database Monitoring) Release Notes