About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Troubleshooting
Problem
SQL30081N error was reported when enabling TLS (Transport Layer Security)
Symptom
Connect to database fails with following error:
SQL30081N A communication error has been detected. Communication protocol
being used: "SSL". Communication API being used: "SOCKETS". Location where
the error was detected: "". Communication function detecting the error:
"sqlccSSLSocketSetup". Protocol specific error code(s): "420", "*", "*".
SQLSTATE=08001
being used: "SSL". Communication API being used: "SOCKETS". Location where
the error was detected: "". Communication function detecting the error:
"sqlccSSLSocketSetup". Protocol specific error code(s): "420", "*", "*".
SQLSTATE=08001
A 420 error code indicates the TLS peer closed the connection. In this case, the Db2 diagnostic log on the server must be inspected. On the Db2 server, a GSKit 407 error may be seen from the SSL function gsk_secure_soc_init:
2021-04-21-20.06.50.147993-420 I2267E484 LEVEL: Error
PID : 32557 TID : 140318414464768 PROC : db2sysc 0
INSTANCE: db2v111 NODE : 000
APPHDL : 0-24
HOSTNAME: MYHOST1
EDUID : 24 EDUNAME: db2agent () 0
FUNCTION: DB2 UDB, common communication, sqlccMapSSLErrorToDB2Error, probe:30
MESSAGE : DIA3604E The SSL function "gsk_secure_soc_init" failed with the
return code "407" in "sqlccSSLSocketSetup".
2021-04-21-20.06.50.147993-420 I2267E484 LEVEL: Error
PID : 32557 TID : 140318414464768 PROC : db2sysc 0
INSTANCE: db2v111 NODE : 000
APPHDL : 0-24
HOSTNAME: MYHOST1
EDUID : 24 EDUNAME: db2agent () 0
FUNCTION: DB2 UDB, common communication, sqlccMapSSLErrorToDB2Error, probe:30
MESSAGE : DIA3604E The SSL function "gsk_secure_soc_init" failed with the
return code "407" in "sqlccSSLSocketSetup".
Document Location
Worldwide
[{"Type":"SW","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PmmAAE","label":"Security and Plug-Ins-\u003EAuthentication"}],"ARM Case Number":"TS005483476","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
Db2 for Linux, UNIX and Windows
Component:
Security and Plug-Ins->Authentication
Software version:
All Version(s)
Document number:
6446149
Modified date:
01 May 2025
UID
ibm16446149
Manage My Notification Subscriptions
