IBM Support

db2 connection fails with error SQL10003C "There are not enough system resources to process the request"

Technical Blog Post


Abstract

db2 connection fails with error SQL10003C "There are not enough system resources to process the request"

Body

 

Db2 connection fails with the following error:

 SQL10003C "There are not enough system resources to process the request"

 

You need to verify in db2diag.log what resource is insufficient. In this case, the following db2diag.log

messages show that in fact the SSL library couldn't be loaded properly.

 

2018-10-16-22.11.23.412895-300 I102091A348     LEVEL: Error

PID   : 12345678      TID : 1       PROC : db2bp

INSTANCE: db2inst1       NODE : 000

HOSTNAME: host1

EDUID  : 1

FUNCTION: DB2 UDB, common communication, sqlccLoadSSLLibrary, probe:998

MESSAGE : DIA3603E SSL was not setup. Return code = "-1879048072".

 

 

2018-10-16-22.11.23.413169-300 I102440A2028     LEVEL: Severe

PID   : 12345678      TID : 1       PROC : db2bp

INSTANCE: db2inst1       NODE : 000

HOSTNAME: host1

EDUID  : 1

FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcCommConnect, probe:10

MESSAGE : ZRC=0x80360053=-2143944621=SQLZ_RC_BDS_INSSYS, SQLT_SQLJC

     "Insufficient system resources"

DATA #1 : String, 11 bytes

CCI Error:

DATA #2 : unsigned integer, 8 bytes

120

CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)

 [0] 0x090000000AAFA1E0 sqljcLogCCIError__FP10sqljCmnMgrPCcP12SQLCC_COND_TUclN35 + 0x2E0

 [1] 0x090000000AAF4B34 sqljcCommConnect__FP10sqljCmnMgr + 0x7B4

 [2] 0x090000000AAF3AC8 sqljcCmnMgrInit__FP10sqljCmnMgrP17SQLCC_COMHANDLE_TPUcUlP14db2UCconHandleUc24sqljcInvokeCommExitStatePP21sqljcCommexitCommInfoP + 0xC8

 [3] 0x090000000AB014F8 sqljrCreateTransport__FP14db2UCconHandle + 0xD8

 [4] 0x090000000A52CCA0 sqljrAssociateTransport__FP14db2UCconHandlePlbP19SQLE_SRVLST_DBENTRYPi + 0x2A0

 [5] 0x090000000AB00838 sqljrConnectBasedOnCatalog__FP14db2UCconHandlePibPb + 0x1D8

...

2018-10-16-22.11.23.413605-300 E104469A346     LEVEL: Warning

PID   : 12345678       TID : 1       PROC : db2bp

INSTANCE: db2inst1       NODE : 000

HOSTNAME: host1

EDUID  : 1

FUNCTION: DB2 UDB, config/install, db2CfgCall, probe:908

DATA #1 : signed integer, 4 bytes

64

DATA #2 : signed integer, 4 bytes

-10003

 

To resolve the problem, verify GSKit is correctly installed with Db2. The following links may be helpful:

(1) GSKit version shipped with Db2 - /support/pages/node/484539
(2) GSKit V8 - Instructions to find current installed version details - /support/pages/node/196175

(3)  Introduction to Global Security Kit installation - https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.swg.tivoli.gskit.install.doc/doc/c0055353.html

 

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm13285945