We have DB2 UDB 8.2 FP 11 on Linux CentOS on our production and backup server. Every night the images are copy / restored from production to backup...a few days ago I noticed that our backup server had a huge number of db2agents and I also kept getting system errors when trying to connect to the db -- I eventually had to stop the database by issuing the 'db2stop force' command. Below are the errors from db2diag.log and also the error code that I got when trying to force applications off --- any thoughts?.. thanks!!!
db2 force applications all
SQL0902C A system error (reason code = "") occurred. Subsequent SQL
statements cannot be processed. SQLSTATE=58005
2011-07-11-16.37.08.646599+000 E646412032E421 LEVEL: Error
PID : 30506 TID : 47909221637536PROC : db2tcpcm
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:125
MESSAGE : ADM7009E An error was encountered in the "TCPIP" protocol support.
A possible cause is that the maximum number of agents has been
Might be a socket ulimit, or you've reached the maximum number of agents as configured. If this number of connected applications is abnormal, you would need to ensure it does not happen again; if it is expected, determine and increase the appropriate limits.