Troubleshooting
Problem
Why did the connection to Db2 database fail with SQL0902C error?
Symptom
Connect to ABC user db2inst1 using <pass>
SQL0902C A system error occurred. Subsequent SQL statements cannot be processed. IBM software support reason code: "". SQLSTATE=58005
db2diag snippet:
db2diag snippet:
2021-10-26-02.00.00.726019-180 I4187278252E498 LEVEL: Severe
PID : 3150 TID : 140153922250496 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
Hostname: abc-xyz
EDUID : 16 EDUNAME: db2ipccm 0
FUNCTION: DB2 UDB, common communication, sqlccGetIPCs, probe:50
RETCODE : ZRC=0x850F0081=-2062614399=SQLO_SSEM_EXCEED_MAX
"Requesting too many semaphores"
DIA8336C Requested too many semaphores.
2021-10-26-02.00.00.726019-180 I4187278252E498 LEVEL: Severe
PID : 3150 TID : 140153922250496 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
Hostname: abc-xyz
EDUID : 16 EDUNAME: db2ipccm 0
FUNCTION: DB2 UDB, common communication, sqlccGetIPCs, probe:50
RETCODE : ZRC=0x850F0081=-2062614399=SQLO_SSEM_EXCEED_MAX
"Requesting too many semaphores"
DIA8336C Requested too many semaphores.
2021-10-26-02.00.00.730926-180 E4187281662E655 LEVEL: Error
PID : 3172 TID : 140309957527296 PROC : db2acd
INSTANCE: db2inst1 NODE : 000
Hostname: abc-xyz
FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::run, probe:200
MESSAGE : ZRC=0xFFFFFC7A=-902
SQL0902C A system error occurred. Subsequent SQL statements cannot
be processed. IBM software support reason code: "".
DATA #1 : <preformatted>
[IBM][CLI Driver] SQL0902C A system error occurred. Subsequent SQL statements cannot be processed. IBM software support reason code: "". SQLSTATE=58005
Document Location
Worldwide
[{"Type":"MASTER","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":"a8m500000008PmFAAU","label":"Operating System or Hardware-\u003EOS Configuration"}],"ARM Case Number":"TS007449272","Platform":[{"code":"PF016","label":"Linux"}],"Version":"All Versions"}]
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
Modified date:
01 May 2025
UID
ibm16541058