|
Problem IT00325
|
Status: Closed |
DB2 IS NOT ABLE TO ACCEPT AN INCOMING CONNECTION IF NUMBER OF INSTANCE THREADS EXCEEDS RLIMIT_NPROC LIMIT |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DB2 database will not be able to accept an incoming connection
if the number of processes/threads (that includes all DB2 EDUs)
running as instance owner exceeds RLIMIT_NPROC. In such scenario
the following message will be logged in the db2diag.log:
2014-01-01-12.00.00.000000+000 E41002E402 LEVEL: Error
(OS)
PID : 15370 TID : 140737131833088PROC :
db2sysc 0
INSTANCE: db2insp1 NODE : 000
EDUID : 17 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, oper system services, sqloSpawnEDU, probe:80
MESSAGE : ZRC=0x8300000B=-2097151989
CALLED : OS, -, pthread_create OSERR: EAGAIN
(11)
NPROC limit is defined only on GNU/Linux operating system. This
APAR will address the issue by overriding default limit for
db2sysc process when instance is started. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Linux *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7 and Fix Pack 10. *
**************************************************************** |
| Local Fix: |
Increase NPROC limit for instance owner and restart the
instance. On recent kernel versions the limit of running process
can
be changed using proc virtual filesystem:
$ echo -n "Max processes=<n_soft>:<n_hard>" > /proc/<pid>/limits
where pid is PID of db2sysc process and n_soft, n_hard are
desired soft and hard limits respectively, e.g:
$ echo -n "Max processes=10240:65535" > /proc/15370/limits |
| Solution |
Problem was first fixed in DB2 version 9.7 and Fix Pack 10. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.03.2014
10.11.2014
10.11.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
