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 9.7 and higher
Keywords
SQL1225N, DIA8336C, ADM7519W, SQLO_SSEM_EXCEED_MAX, semaphores, SysV semget, resource , KBA , semaphores , sql1225n , adm7519w , dia8336c , 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.