UIM DB2 probe false alarms: SQL30081N A communication error has been detected
Article ID: 144582
Updated On:
Products
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.
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.
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
Attachments
Feedback
Yes
No
Powered by
