docs-site icon indicating copy to clipboard operation
docs-site copied to clipboard

[Troubleshooting tip] Error message help for Db2 CLI if the wrong port is specified

Open Joe-Winchester opened this issue 3 years ago • 4 comments

1. Slack conversation link (if any)

currently im getting this error and wanted to know if you may know a fix
4:59
DB2 ODBC Driver Error: [node-ibm_db] SQL_ERROR
Error Details:
Error:    [IBM][CLI Driver] SQL30081N  A communication error has been detected. Communication protocol being used: "TCP/IP".  Communication API being used: "SOCKETS".  Location where the error was detected: "9.63.66.57".  Communication function detecting the error: "recv".  Protocol specific error code(s): "10054", "*", "0".  SQLSTATE=08001
SQLCODE:  -30081
SQLSTATE: 08001

2. Choose a title

Error message help for SQLCODE: -30081 and SQLSTATE: 08001

3. Symptom

4. Solution

This message occurs if the secport is being used instead of the unsecured port. Refer to the DSN400I message.

Update the https://docs.zowe.org/stable/user-guide/cli-db2plugin.htm page to include this message

Joe-Winchester avatar Mar 18 '21 08:03 Joe-Winchester

@AbhishekJamhoriya will work on this issue. Thank you for taking the time to contribute to Zowe docs!

nannanli avatar Nov 09 '21 01:11 nannanli

Hi, @nannanli please assign me this work.

AbhishekJamhoriya avatar Nov 09 '21 03:11 AbhishekJamhoriya

Hi, @nannanli made the required changes please check my PR.

AbhishekJamhoriya avatar Jan 01 '22 20:01 AbhishekJamhoriya

We would like to cover all applicable plug-ins. We will create a draft doc proposal.

JTonda avatar Dec 05 '22 16:12 JTonda

Closing with PR 2630

anaxceron avatar Feb 08 '23 21:02 anaxceron