db2diag.log

2008-04-13-10.14.48.282664 Instance:db2admin Node:000
PID:1176(db2ipccm) TID:1024 Appid:none
base sys utilities sqleGetAgentFromPool Probe:30

DiagData
0x7FFF9E48 : 0xFFFFFB37 …7

2008-04-13-10.14.48.326160 Instance:db2admin Node:000
PID:1176(db2ipccm) TID:1024 Appid:none
base sys utilities sqleGetAgent Probe:70

Agent not allocated, sqlcode = -1225

db2admin.nfy

2008-04-13-09.55.53.979548 Instance:db2admin Node:000
PID:1179(db2tcpcm) TID:1024 Appid:none
base sys utilities sqleGetAgent Probe:100

ADM7519W DB2 could not allocate an agent. The SQLCODE is “-1225”.

2008-04-13-09.55.53.986481 Instance:db2admin Node:000
PID:1179(db2tcpcm) TID:1024 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.

for this we need to tune db2 memory parmetres and kernel paramters

DB2 recommendations for kernel parameters

http://www.ibm.com/developerworks/linux/linux390/perf/tuning_rec_database_DB2.html

db2:~ # sysctl -a|grep kernel.msg

kernel.msgmnb = 65536
kernel.msgmni = 1024
kernel.msgmax = 65536

Advertisements