IBM Support

Db2 running within a systemd slice (typically when started by Db2 Fault Monitor) might fail to start or reject a connection due to pthread_create OSERR: EAGAIN (11) if TasksMax limit is set too low.

Troubleshooting


Problem

Db2 running within a systemd slice (typically when started by Db2 Fault Monitor) might fail to start or reject a connection due to pthread_create OSERR: EAGAIN (11) if TasksMax limit is set too low.

 

 

Symptom

db2start might fail with SQL1225N and a following message logged to db2diag.log:

2018-12-05-11.00.34.332127+060 I52280E490            LEVEL: Severe
PID     : 11859                TID : 139906236016384 PROC : db2sysc 0
INSTANCE: db2v111              NODE : 000
HOSTNAME: db2host1
EDUID   : 1                    EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, base sys utilities, sqeAgentServices::CreateIdleAgent, probe:110
RETCODE : ZRC=0xFFFFFB37=-1225
          SQL1225N  The request failed because an operating system process,
          thread, or swap space limit was reached.

CALLED  : OS, -, pthread_create                   OSERR: EAGAIN (11)
DATA #1 : Codepath, 8 bytes
5:10:25:35

or, depending on the limits enforced, connections after a certain threshold will be rejected with SQL1225N error returned to the application and an error similar to this one logged by db2ipccm or db2tcpcm EDUs to db2diag.log:

2018-12-05-11.00.34.326462+060 E50682E470            LEVEL: Error (OS)
PID     : 11859                TID : 139906236016384 PROC : db2sysc 0
INSTANCE: db2v111              NODE : 000
HOSTNAME: db2host1
EDUID   : 1                    EDUNAME: db2ipccm 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

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.

Document Information

Modified date:
01 May 2025

UID

ibm10744121

Page Feedback