|Product:||DBConnectivity Products for IBM Db2 for i (HiT ODBC/400, HiT OLEDB/400, Ritmo/i, HiT JDBC/400)|
|Summary:||Host Ping Test error WSAECONNREFUSED 10061 occurs when QSERVER not running correctly|
When using the Toolbox to test the connection to the Db2 server, the following error can occur in the Host Ping Test:
“WSAECONNREFUSED : Connection refused
Unsuccessful socket connection to the host.”
The error occurs if either the QSERVER subsystem is not running, or one of the necessary prestart jobs for native TCP/IP is not active. Try the following:
- Run the following command and verify that both QZDASOINIT and QZDASRVSD are active:
- If you receive an error stating QSERVER is not active, run STRSBS QSERVER to start it.
- If QSERVER is active, but you don't see QZDASOINIT and QZDASRVSD in the list received from WRKSBSJOB QSERVER, run:
- Once this is completed, rerun WRKSBSJOB QSERVER to verify that the two prestart jobs have in fact started.
- Retry the connection.