Connections to DB2 are auto generated

[D***@hotmail.com]

Hello,
I have several db2(8.2) databases cataloged on my machine. My machine is Windows 2000.
Sometimes I run into problem that connection limit in the database is exceeded (which is 400), because connections are AUTO generated on my machine.
I am quite beginner in DB2 and can't figure out why it happens.
If I reregister database using configuration assistant -> this does not solve problem.

Thanks for your help,
Diana M

[Mark A]

Post by D***@hotmail.com
Hello,
I have several db2(8.2) databases cataloged on my machine. My machine is Windows 2000.
Sometimes I run into problem that connection limit in the database is
exceeded (which is 400), because connections are AUTO generated on my
machine.
I am quite beginner in DB2 and can't figure out why it happens.
If I reregister database using configuration assistant -> this does not solve problem.
Thanks for your help,
Diana M

Where are the connections coming from? Do a "db2 list applications show
detail" and the ip address of the connection (in hex) is shown in the
output. Many application connection pooling software products will
automatically connect.

You can increase the number of connections allowed to 800 by doing this, and
restart db2:

db2 update dbm cfg using maxagents 800

[D***@hotmail.com]

I use 'DB2 Monitor' tool which shows the application name and OS user. All connections are coming from my PC (OS user is my Windows user name) and application name is javaw.exe.

[D***@hotmail.com]

And forgot to add that 'db2 list applications show detail' application id shows my ip address (in hex) for all those autogenerated connections.

[D***@hotmail.com]

This post might be inappropriate. Click to display it.

[Mark A]

This post might be inappropriate. Click to display it.

[Blair Kenneth Adamache]

If you cannot reduce the number of connections, can you use DB2's
Connection Concentrator? It comes as a standard part of DB2?

Post by D***@hotmail.com
Hello,
I have several db2(8.2) databases cataloged on my machine. My machine is Windows 2000.
Sometimes I run into problem that connection limit in the database is exceeded (which is 400), because connections are AUTO generated on my machine.
I am quite beginner in DB2 and can't figure out why it happens.
If I reregister database using configuration assistant -> this does not solve problem.
Thanks for your help,
Diana M

[D***@hotmail.com]

Thanks for your suggestion.
I did that. Now I have to monitor if the problem still persist(it may take some time)