Symptom
You can not execute any SQL statement using DB2 CLP.
SQL0902C A system error occurred. Subsequent SQL statements cannot be processed.
IBM software support reason code: "". SQLSTATE=58005
db2diag.log
2017-08-08-11.30.47.802805+540 I12593456E493 LEVEL: Severe
PID : 123456 TID : 1 PROC : db2fmp
INSTANCE: db2abc NODE : 000 DB : abc
APPID : *LOCAL.db2abc.170807151441
HOSTNAME: abcd
FUNCTION: DB2 UDB, database application extension for DB/DBM config, dbm_get_cfg, probe:30
MESSAGE : SQL0902C A system error occurred. Subsequent SQL statements cannot
be processed. IBM software support reason code: "".
2017-08-08-11.30.47.844304+540 I12593950E464 LEVEL: Severe
PID : 123456 TID : 1 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000
HOSTNAME: abcd
EDUID : 16 EDUNAME: jdoe 3
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.
In an earlier db2diag.log, you see
2017-08-08-00.00.00.230954+540 I2165284E412 LEVEL: Severe
PID : 123456 TID : 1 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000
HOSTNAME: jdoe
FUNCTION: DB2 UDB, oper system services, sqlo_waitlist::initialize, probe:10
MESSAGE : SysV semget failed with errno:
DATA #1 : Hexdump, 4 bytes
0x00007F8E31FFDAF0 : 1C00 0000 ....
2017-08-08-00.00.00.259320+540 I2165697E414 LEVEL: Severe
PID : 123456 TID :1 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000
HOSTNAME: abcd
FUNCTION: DB2 UDB, oper system services, sqloGetShrEDUWaitElem, probe:70
MESSAGE : waitlist initialization failed, zrc=
DATA #1 : Hexdump, 4 bytes
0x00007F8E31FFDB9C : 8100 0F85 ....
2017-08-08-00.00.00.287382+540 E2166112E476 LEVEL: Severe
PID : 123456 TID : 1 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000
HOSTNAME: abcd
FUNCTION: DB2 UDB, oper system services, sqloEDUEntry, probe:10
CALLED : DB2 UDB, oper system services, sqloGetShrEDUWaitElem
RETCODE : ZRC=0x850F0081=-2062614399=SQLO_SSEM_EXCEED_MAX
"Requesting too many semaphores"
DIA8336C Requested too many semaphores.
2017-08-08-00.00.00.314470+540 I2166589E416 LEVEL: Severe
PID : 123456 TID : 1 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000
HOSTNAME: abcd
EDUID : 16 EDUNAME: jdoe 3
FUNCTION: DB2 UDB, global services, sqzEDUObj::StartEDU, probe:10
RETCODE : ZRC=0x870F00F2=-2029059854=SQLO_NORES
"no resources to create process or thread"
2017-08-08-00.00.00.523897+540 I2167884E498 LEVEL: Severe
PID : 123456 TID : 1 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000
HOSTNAME: abcd
EDUID : 16 EDUNAME: jdoe 3
FUNCTION: DB2 UDB, base sys utilities, sqeAgentServices::RequestAgentForAppl, probe:2118
RETCODE : ZRC=0xFFFFFB37=-1225
SQL1225N The request failed because an operating system process,
thread, or swap space limit was reached.
Read more...
Environment
IBM Db2 on Linux and Unix operating system
Db2 11.1 or Db2 10.5
Keywords
SQL1225N, DIA8336C, ADM7519W, SQLO_SSEM_EXCEED_MAX, semaphores, SysV semget, resource , KBA , dia8336c , adm7519w , semaphores , sql1225n , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.