IBM Support

Db2 LUW gateway: sqljrDrdaArConnect raise error SQLJC_ERROR_TIMEOUT with SQLCODE -30081 and selectForConnectTimeout on EDU db2spmrsy

Troubleshooting


Problem

sqljrDrdaArConnect raise error SQLJC_ERROR_TIMEOUT with SQLCODE -30081

Symptom

Below are the error captured in db2diag.log
  
2020-07-02-15.56.51.585709+120 I12938560E929         LEVEL: Info
PID     : 128087               TID : 140082090600192 PROC : db2sysc
INSTANCE: xxxxxxxx             NODE : 000            DB   : xxxx
APPHDL  : 0-6
HOSTNAME: xxxxxx
EDUID   : 20                   EDUNAME: db2spmrsy
FUNCTION: DB2 UDB, DRDA Application Requester, sqljrDrdaArConnect, probe:400
MESSAGE : ZRC=0x8136001A=-2127167462=SQLJC_ERROR_TIMEOUT "CONNECTION TIMED OUT"
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -30081   sqlerrml: 62
 sqlerrmc: 115 * * TCP/IP SOCKETS 134.227.125.33 selectForConnectTimeout
 sqlerrp : SQLJCMN
 sqlerrd : (1) 0x8136001A      (2) 0x0000001A      (3) 0x00000000
           (4) 0x00000000      (5) 0x00000000      (6) 0x00000000
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
           (7)      (8)      (9)      (10)        (11)
 sqlstate:

2020-07-02-15.56.51.586109+120 I12939490E498         LEVEL: Severe
PID     : 128087               TID : 140082090600192 PROC : db2sysc
INSTANCE: xxxxxxxx             NODE : 000            DB   : xxxx
APPHDL  : 0-6
HOSTNAME: xxxxxxx
EDUID   : 20                   EDUNAME: db2spmrsy
FUNCTION: DB2 UDB, Connection Manager, sqleuUCagentDrdaArTermConnect, probe:10
MESSAGE : ZRC=0x800F00B1=-2146500431=SQLO_EDU_EXIT_LIST_NOT_FOUND
          "Can't remove an exit list because it wasn't found"

 

Document Location

Worldwide

[{"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":"a8m500000008PkdAAE","label":"Connectivity"}],"ARM Case Number":"TS003895526","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.

Document Information

Modified date:
01 May 2025

UID

ibm16335709

Page Feedback