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.
SAP Knowledge Base Article - Preview