Symptom
You notice Db2 database fails to start up.
The database log (db2diag.log) shows OS errors:
2023-06-12-09.05.46.357754-360 I30871949E367 LEVEL: Severe
PID : 3428 TID : 139667542370048 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000
HOSTNAME: abcdefgh0001
EDUID : 17 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, global services, sqzEDUObj::StartEDU, probe:10
RETCODE : ZRC=0x8300000B=-2097151989
2023-06-12-09.05.46.429637-360 I30873097E502 LEVEL: Severe
PID : 3428 TID : 139667542370048 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000
HOSTNAME: abcdefgh0001
EDUID : 17 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, base sys utilities, sqeAgentServices::RequestAgentForAppl, probe:2136
RETCODE : ZRC=0xFFFFFB37=-1225
SQL1225N The request failed because an operating system process,
thread, or swap space limit was reached.
2023-06-12-09.05.46.894486-360 E30875266E414 LEVEL: Warning
PID : 3428 TID : 139667538175744 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000
HOSTNAME: abcdefgh0001
EDUID : 18 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, base sys utilities, sqeAgentServices::RequestAgent, probe:2976
MESSAGE : ADM7519W DB2 could not allocate an agent. The SQLCODE is "-1225".
2023-06-12-09.05.45.777150-360 E30875681E477 LEVEL: Error (OS)
PID : 3428 TID : 139667533981440 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000
HOSTNAME: abcdefgh0001
EDUID : 19 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, oper system services, sqloSpawnEDU, probe:80
MESSAGE : ZRC=0x8300000B=-2097151989
CALLED : OS, -, pthread_create OSERR: EAGAIN (11)
DATA #1 : Codepath, 8 bytes
5:10:25:35
OS log (/var/log/messages)
2023-06-12T09:05:45.777724-06:00 abcdefgh0001 kernel: [100043.176422] cgroup: fork rejected by pids controller in /system.slice/shc-salt-minion.service
2023-06-12T09:05:48.219245-06:00 abcdefgh0001 salt-minion[1709]: Resource temporarily unavailable (src/thread.cpp:269)
Read more...
Environment
- SUSE Linux Enterprise Sever 12
- SAP on IBM Db2 for Linux, UNIX, and Windows
Product
Keywords
fork rejected, pids controller, system.slice, EAGAIN (11), ADM7519W, "-1225" , KBA , BC-OP-LNX-SUSE , SUSE Linux , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.