SQL1225N The request failed because an operationg system process XXX reached. SQLSTATE=57049?

系统Linux 64 bit GNU/Linux
实例用户下执行:
db2 connect to testdb
SQL1225N The request failed because an operationg system process, thread, or swap space limit was reached. SQLSTATE=57049

  • db2inst1.nfy 信息如下: 2020-09-21-11.21.16.593685 Instance:db2i4jn Node:000 PID:12575(db2agent (FEPDB) 0) TID:645902896 Appid:*LOCAL.db2i4jn.200921032114 base sys utilities sqeAgentServices::RequestAgent Probe:2958 Database:FEPDB ADM7519W DB2 could not allocate an agent. The SQLCODE is "-1225".  2020-09-21-11.21.16.675331 Instance:db2i4jn Node:000 PID:12575(db2agent (FEPDB) 0) TID:645902896 Appid:*LOCAL.db2i4jn.200921032114 base sys utilities sqleDoForceDBShutdownFODC Probe:10 Database:FEPDB ADM14001C An unexpected and critical error has occurred: "ForceDBShutdown". The instance may have been shutdown as a result. "Automatic" FODC (First Occurrence Data Capture) has been invoked and diagnostic information has been recorded in directory "/home/db2i4jn/sqllib/db2dump/FODC_ForceDBShutdown_2020-09-21-11.21.16.675027_0 000/". Please look in this directory for detailed evidence about what happened and contact IBM support if necessary to diagnose the problem.  2020-09-21-11.21.16.675546 Instance:db2i4jn Node:000 PID:12575(db2agent (FEPDB) 0) TID:645902896 Appid:*LOCAL.db2i4jn.200921032114 base sys utilities sqleDoForceDBShutdownFODC Probe:16482 Database:FEPDB ADM7518C The database manager has shut down the following database because a severe error has occurred: "FEPDB ".  2020-09-21-11.21.21.879793 Instance:db2i4jn Node:000 PID:12575(db2tcpcm 0) TID:675263024 Appid:none base sys utilities sqeAgentServices::RequestAgent Probe:2958 ADM7519W DB2 could not allocate an agent. The SQLCODE is "-1225".  2020-09-21-11.21.21.880065 Instance:db2i4jn Node:000 PID:12575(db2tcpcm 0) TID:675263024 Appid:none common communication sqlcctcpconnmgr_child Probe:125 ADM7009E An error was encountered in the "TCPIP" protocol support. A possible cause is that the maximum number of agents has been exceeded.  2020-09-21-11.21.22.614275 Instance:db2i4jn Node:000 PID:12575(db2tcpcm 0) TID:671068720 Appid:none base sys utilities sqeAgentServices::RequestAgent Probe:2958 ADM7519W DB2 could not allocate an agent. The SQLCODE is "-1225".  2020-09-21-11.21.22.614499 Instance:db2i4jn Node:000 PID:12575(db2tcpcm 0) TID:671068720 Appid:none common communication sqlcctcpconnmgr_child Probe:125 ADM7009E An error was encountered in the "TCPIP" protocol support. A possible cause is that the maximum number of agents has been exceeded.
    2020-09-21

2回答

libai21libai21  软件架构设计师 , 海通证券
zhuhaiqiang挚爱咖啡赞同了此回答
2020-09-21-10.07.42.114992+480 I1427994E628 LEVEL: Severe PID : 3665 TID : 2305843009859596848PROC : db2sysc 0 INSTANCE: db2i4jn NODE : 000 DB : FEPDB APPHDL : 0-11 APPID: *LOCAL.db2i4jn.200921020739 AUTHID : DB2I4JN HOSTNAME: jntestdb EDUID : 26 EDU...显示全部

2020-09-21-10.07.42.114992+480 I1427994E628 LEVEL: Severe

PID : 3665 TID : 2305843009859596848PROC : db2sysc 0

INSTANCE: db2i4jn NODE : 000 DB : FEPDB

APPHDL : 0-11 APPID: *LOCAL.db2i4jn.200921020739

AUTHID : DB2I4JN HOSTNAME: jntestdb

EDUID : 26 EDUNAME: db2agent (FEPDB) 0

FUNCTION: DB2 UDB, base sys utilities, sqeAgentServices::RequestAgentForAppl, probe:2118

RETCODE : ZRC=0xFFFFFB37=-1225

SQL1225N The request failed because an operating system process,

thread, or swap space limit was reached.

查看db2inst1.nfy,里面会有更详细的信息。



2020-09-21-11.21.21.880065 Instance:db2i4jn Node:000

PID:12575(db2tcpcm 0) TID:675263024 Appid:none

common communication sqlcctcpconnmgr_child Probe:125

ADM7009E An error was encountered in the "TCPIP" protocol support. A possible

cause is that the maximum number of agents has been exceeded.

从db2inst1.nfy里面看,是达到最大的agents数量
看看数据库的参数
db2 get dbm cfg |grep -i max
看看max_coordagents,max_connections的参数值
另外看看当前的连接情况
 db2 list active databases
ps -ef |grep -i db2

收起
 2020-09-21
浏览153
aixchina 邀答
  • 您好,也报错,ADM7519W DB2 could not allocate an agent. The SQLCODE is "-1225",其他详细信息见主内容附件。
    2020-09-21
  • [此评论已删除]
    2020-09-21
daihoodaihoo  软件开发工程师 , 酸菜馆
操作系统进程数上限调大点试试以centos为例,修改 /etc/security/limits.d/20-nproc.conf  或  /etc/security/limits.d/90-nproc.conf soft nproc 65535 #打开进程数 hard nproc 65535 #打开进程数 显示全部

操作系统进程数上限调大点试试
以centos为例,修改 /etc/security/limits.d/20-nproc.conf  或  /etc/security/limits.d/90-nproc.conf

  • soft nproc 65535 #打开进程数
  • hard nproc 65535 #打开进程数
收起
 2020-09-21
浏览112
  • 已经上传当前系统进程数图片,帮忙看看
    2020-09-21
  • 加上用户名和密码连接一下,试试看,啥数据库版本啊,谁不是本地连接ipc资源不够用了,另外数据库能重启吗?
    2020-09-21

核心数据库服务器选型优先顺序调查

发表您的选型观点,参与即得50金币。

问题状态

  • 发布时间:2020-09-21
  • 关注会员:3 人
  • 问题浏览:989
  • 最近回答:2020-09-21