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

系统Linux 64 bit GNU/Linux实例用户下执行:db2 connect to testdbSQL1225N The request failed because an operationg system process, thread, or swap space limit was 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

收起
参与12
  • 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

查看其它 1 个回答daihoo的回答

daihoodaihoo软件开发工程师酸菜馆

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

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

回答者

daihoo
软件开发工程师酸菜馆

daihoo 最近回答过的问题

回答状态

  • 发布时间:2020-09-21
  • 关注会员:3 人
  • 回答浏览:1761
  • X社区推广