CNDBA社区
$db2 ? SQL1225N
SQL1225N The request failed because an operating system process,
thread, or swap space limit was reached.
Explanation:
An operating system process, thread, or swap space limit was reached.
You can find more information about the problem in the administration
notification log.
User response:
Check the administration notification log to determine which limit was
reached and increase that limit.
sqlcode: -1225
sqlstate: 57049
Problem
DB2 UDB running on Linux Redhat 6 receives SQL1225N. Possible symtpom DB2 server not responding to applications.
Cause
Linux Redhat 6 has default nproc setting of 1024. nproc is the maximum user process limit.
When this limit is reached for db2sysc process, operation system will fail to generate new threads or agents.
Environment
Linux Redhat 6
Diagnosing The Problem
db2diag.log shows below messages:
2013-03-30-04.00.32.784330-420 I70001596E347 LEVEL: Severe
PID : 24836 TID : 139728603047680PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 15 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, base sys utilities, sqeAgentServices::
RequestAgentForAppl, probe:130
RETCODE : ZRC=0xFFFFFB37=-1225
2013-03-30-04.01.11.212266-420 I71239666E330 LEVEL: Severe
PID : 24836 TID : 139728565298944PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 24 EDUNAME: db2disp 0
FUNCTION: DB2 UDB, global services, sqzEDUObj::StartEDU, probe:10
RETCODE : ZRC=0x8300000B=-2097151989
2013-03-30-04.01.11.212328-420 I71239997E332 LEVEL: Error
PID : 24836 TID : 139728565298944PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 24 EDUNAME: db2disp 0
FUNCTION: DB2 UDB, base sys utilities, sqeBsuEdu::StartEDU, probe:96
RETCODE : ZRC=0x8300000B=-2097151989
2013-03-30-04.01.11.212389-420 I71240330E371 LEVEL: Error
PID : 24836 TID : 139728565298944PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 24 EDUNAME: db2disp 0
FUNCTION: DB2 UDB, base sys utilities, sqeAgent::startAgent, probe:2323
RETCODE : ZRC=0x8300000B=-2097151989
DATA #1 : signed integer, 4 bytes
2013-03-30-04.28.00.516214-420 I71977971E330 LEVEL: Severe
PID : 24836 TID : 139728565298944PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 24 EDUNAME: db2disp 0
FUNCTION: DB2 UDB, global services, sqzEDUObj::StartEDU, probe:10
RETCODE : ZRC=0x8300000B=-2097151989
2013-03-30-05.03.12.653758-420 I72014771E347 LEVEL: Severe
PID : 24836 TID : 139728594659072PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 17 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, base sys utilities, sqeAgentServices::
RequestAgentForAppl, probe:130
RETCODE : ZRC=0xFFFFFB37=-1225
2013-03-30-07.44.50.137596-420 E72015119E402 LEVEL: Error (OS)
PID : 24836 TID : 139728594659072PROC : db2sysc 0
INSTANCE: db2inst1 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)
.
Resolving The Problem
Increase user limit of maximum user processes.
1.On RHEL 6, the user limit for nproc is set in the /etc/security/limits.d/90-nproc.conf file. This file
overrides the settings in the /etc/security/limits.conf file.
To update the user limit, you must either edit the file in the /etc/security/limits.d directory or remove the file and add a line to the /etc/security/limits.conf file.
2.可能是数据库服务器资源不足，内存、paging、nproc等。
版权声明：本文为博主原创文章，未经博主允许不得转载。
DB2
