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