-1

I am configuring SSL in db2 AIX server. Getting the following error in diaglog:

"gsk_secure_soc_init" failed with error code "410" in "sqlccSSLSocketSetup"

DB2 version:9.7 FP10

All SSL parameters are set and have generated self signed certificate.

Please help me to resolve this issue.

Chiragkumar Thakar
  • 3,616
  • 5
  • 37
  • 49
Shridhar Kulkarni
  • 21
  • 6

1 Answers1

0

Have a look at the following article. Sounds like you may need to look into your GSKit configuration: http://www-01.ibm.com/support/docview.wss?uid=swg21693912

pavel_sustr
  • 307
  • 1
  • 4
  • Thank you for the comment. Do you mean to say it's the problem from application side. Like missing configurations?Because on server side configuration looks perfect for me. – Shridhar Kulkarni Aug 17 '15 at 15:34
  • Yes. It might be best to paste the entire db2diag.log entry. There you will see the process name, application ID, and thread ID. Those three elements can be used to map to the executing application. – pavel_sustr Aug 17 '15 at 15:40
  • 2015-08-17-10.50.03.202094-300 I970720A475 LEVEL: Error PID : 15139006 TID : 17639 PROC : db2sysc 0 INSTANCE: db2instd NODE : 000 DB : ERDDEV APPHDL : 0-16461 EDUID : 17639 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 "410" in "sqlccSSLSocketSetup". – Shridhar Kulkarni Aug 17 '15 at 15:53
  • 2015-08-17-10.50.03.202417-300 I971196A726 LEVEL: Info PID : 15139006 TID : 17639 PROC : db2sysc 0 INSTANCE: db2instd NODE : 000 DB : ERDDEV APPHDL : 0-16461 EDUID : 17639 EDUNAME: db2agent () 0 FUNCTION: DB2 UDB, DRDA Application Server, sqljsInitAgent, probe:10 DATA #1 : String, 15 bytes sqlccinit rc = DATA #2 : unsigned integer, 4 bytes 54 DATA #3 : Communication Failure Condition, PD_TYPE_COMCONDITION, 284 bytes – Shridhar Kulkarni Aug 17 '15 at 15:53
  • Communication Condition SEVERITY = 0 NUMBER TOKENS = 7 MSG TOKEN[0] = 410 MSG TOKEN[1] = * MSG TOKEN[2] = * MSG TOKEN[3] = SSL MSG TOKEN[4] = SOCKETS MSG TOKEN[5] = MSG TOKEN[6] = sqlccSSLSocketSetup – Shridhar Kulkarni Aug 17 '15 at 15:54
  • 2015-08-17-10.50.03.202588-300 I971923A470 LEVEL: Info PID : 15139006 TID : 17639 PROC : db2sysc 0 INSTANCE: db2instd NODE : 000 DB : ERDDEV APPHDL : 0-16461 EDUID : 17639 EDUNAME: db2agent () 0 FUNCTION: DB2 UDB, DRDA Application Server, sqljsDrdaAsInnerDriver, probe:10 MESSAGE : ZRC=0x824B0001=-2109014015=SQLJS_ICE "Internal Error" DIA8532C An internal processing error has occurred. – Shridhar Kulkarni Aug 17 '15 at 15:54
  • 2015-08-17-10.50.14.693729-300 I974453A425 LEVEL: Info PID : 15139006 TID : 2057 PROC : db2sysc 0 INSTANCE: db2instd NODE : 000 EDUID : 2057 EDUNAME: db2tcpcm 0 FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:103 MESSAGE : DIA3421W "TCPIP" protocol support: Environment Variable value "DB2SOSNDBUF" = "65536" is "accepted". – Shridhar Kulkarni Aug 17 '15 at 15:55
  • 2015-08-17-10.50.14.694086-300 I975305A393 LEVEL: Info PID : 15139006 TID : 2057 PROC : db2sysc 0 INSTANCE: db2instd NODE : 000 EDUID : 2057 EDUNAME: db2tcpcm 0 FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:117 MESSAGE : DIA3219I Client connecting from IP address = "10.240.1.36", port = "42524". – Shridhar Kulkarni Aug 17 '15 at 15:55
  • Above are the logs. Yeah as you said it will be easy analyse more on diag logs. Please help me with this issue. – Shridhar Kulkarni Aug 17 '15 at 15:57
  • OK, so the problem is coming from APPHDL : 0-16461 EDUID : 17639 EDUNAME: db2agent. A simple `LIST APPLICATIONS SHOW DETAIL` or `GET SNAPSHOT FOR APPLICATIONS` will tell you where the app came from. HTH. – pavel_sustr Aug 17 '15 at 16:42
  • Hi Pavel, sorry for the delay will post list application show detail results here: – Shridhar Kulkarni Aug 18 '15 at 12:14
  • CONNECT Auth Id Application Name Appl. Application Id Seq# Number of Coordinating DB Coordinator Status Status Change Time DB Name DB Path Handle Agents partition number pid/thread ------------------------------------------------------------------------------------------- WTXDEV1 db2fw7 7763 *LOCAL.DB2.150818124914 00001 1 0 13992 Connect Completed Not Collected ERDDEV /db/db2instd/db2data/erddev/db2instd/NODE0000/SQL00001/ – Shridhar Kulkarni Aug 18 '15 at 13:05
  • I have added just one application show details: as I can't paste here everything. We can't even attach the file here I guess. – Shridhar Kulkarni Aug 18 '15 at 13:06