IBM Support

ECONNREFUSED (79) "Connection refused" message in the db2diag.log for the db2hmon process.

Troubleshooting


Problem

Receiving ECONNREFUSED messages in the db2diag.log and not sure why.

Symptom

The db2diag.log will contain messages similar to the following:

2008-09-18-08.05.31.780517-420 E14972210A808 LEVEL: Error (OS)
PID : 565488 TID : 772 PROC : db2hmon 0
INSTANCE: db2ipec NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:20
MESSAGE :
ZRC=0x810F0019=-2129723367=SQLO_CONN_REFUSED "Connection refused" 
CALLED : OS, -, connect
OSERR :
ECONNREFUSED (79) "Connection refused" 
DATA #1 : String, 32 bytes
Unable to connect socket on path
DATA #2 : socket, 4 bytes
8
DATA #3 : sockaddr, 34 bytes
0x00000001103DA658 : 0001 2F68 6F6D 652F 6462 3261 732F 6461
../home/db2as/da
0x00000001103DA668 : 732F 746D 702F 6461 736E 616D 6564 7069
s/tmp/dasnamedpi
0x00000001103DA678 : 7065 pe
DATA #4 : File name, 32 bytes
/home/db2as/das/tmp/dasnamedpipe
 

Cause

The DB2 Health Monitor periodically wakes up and checks for a connection to the DB2 administration server (DAS).

Resolving The Problem

This type of error is reported when the DAS (DB2 administration server) is not active. When the health monitor wakes up it checks for a connection to the DAS. In this case the connection is refused as either the DAS does not exist or it is not started.

Recommendations:

  • Ensure that the DAS is started.
    Use the following command logged in as the DAS user:

    db2admin start

  • If the DAS is started, but the messages continue in the db2diag.log then try dropping and recreating the DAS.
    Steps:
    1. DAS user:
      db2admin stop
      db2 get get admin cfg > dasconfg.txt
    2. user root:
      /usr/opt/db2_08_01/instance> ./daslist
      /usr/opt/db2_08_01/instance> ./dasdrop
      /usr/opt/db2_08_01/instance> ./dascrt -u userID
    3. DAS user
      db2admin start.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 Tools - db2diag.log","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21328644