470,821 Members | 2,032 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,821 developers. It's quick & easy.

Number of simultaneous connection

Hi all,
I'm new with DB2 database, and working on AIX 5.2 with DB2 v8
Just a question regarding the similaneous connection. I'd like to know
how many simultaneous connections that I have in a given time! Do you
know how to get this information?

Thanks for your help

Doug

Feb 21 '06 #1
10 5747
cd***@sopragroup.com wrote:
Hi all,
I'm new with DB2 database, and working on AIX 5.2 with DB2 v8
Just a question regarding the similaneous connection. I'd like to know
how many simultaneous connections that I have in a given time! Do you
know how to get this information?

Thanks for your help

Doug

This will be driven by how much RAM you have available.

Larry Edelstein
Feb 21 '06 #2
cd***@sopragroup.com wrote:
Hi all,
I'm new with DB2 database, and working on AIX 5.2 with DB2 v8
Just a question regarding the similaneous connection. I'd like to know
how many simultaneous connections that I have in a given time! Do you
know how to get this information?

Thanks for your help

Doug

There is a DB CFG parameter for that called MAX_CONNECTIONS. So it's
your choice.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Feb 21 '06 #3
Thanks Larry, Serge

I'd like to optimize MAX_CONNECTIONS value, but I don't know how many
simultaneous connections that I have in peak time

Doug

Feb 21 '06 #4
cd***@sopragroup.com wrote:
Thanks Larry, Serge

I'd like to optimize MAX_CONNECTIONS value, but I don't know how many
simultaneous connections that I have in peak time

Doug


You can get this information in a number of ways:

1. GET SNAPSHOT FOR DATABASE will give point-in-time information
including number of connections;

2. LIST APPLICATIONS will also show all connections for the "instance"

Bob
Feb 21 '06 #5
In article <46************@individual.net>, Bob [IBM]
(Bo********@gmail.com) says...
cd***@sopragroup.com wrote:
Thanks Larry, Serge

I'd like to optimize MAX_CONNECTIONS value, but I don't know how many
simultaneous connections that I have in peak time

Doug


You can get this information in a number of ways:

1. GET SNAPSHOT FOR DATABASE will give point-in-time information
including number of connections;

2. LIST APPLICATIONS will also show all connections for the "instance"

Bob


And if you want to monitor these numbers over a period of time you
can define an 'event monitor for database'. This way the statistics
will automatically be saved everytime the database is deactivated.
Feb 21 '06 #6
Take a SNAPSHOT for DATABASE and look for the monitor element "High
water mark for connections". It shows you the max. number of
simultaneous connections since the database was activated.

HTH
Joachim

Feb 21 '06 #7
Thanks everybody

Have a nice day

D.

Feb 21 '06 #8
Ian
Bob [IBM] wrote:
You can get this information in a number of ways:

1. GET SNAPSHOT FOR DATABASE will give point-in-time information
including number of connections;


Actually, you probably want GET SNAPSHOT FOR DATABASE MANAGER, and look
for the "High water mark for coordinating agents".

MAX_CONNECTIONS is defined at the instance level, and if you have
multiple databases in your instance it won't be helpful to know only
the connections from a single database.

Feb 21 '06 #9
Ian wrote:
Bob [IBM] wrote:
You can get this information in a number of ways:

1. GET SNAPSHOT FOR DATABASE will give point-in-time information
including number of connections;


Actually, you probably want GET SNAPSHOT FOR DATABASE MANAGER, and look
for the "High water mark for coordinating agents".

MAX_CONNECTIONS is defined at the instance level, and if you have
multiple databases in your instance it won't be helpful to know only
the connections from a single database.


Ian -- it was not I who recommended MAX_CONNECTIONS ... I still stand by
the review at the db level rather than the instance level ... IMHO
knowing how many connections at an instance level is less useful
depending on the activity on the databases.

Bob
Feb 21 '06 #10
Ian
Bob [IBM] wrote:

Ian -- it was not I who recommended MAX_CONNECTIONS ... I still stand by
the review at the db level rather than the instance level ... IMHO
knowing how many connections at an instance level is less useful
depending on the activity on the databases.


True enough. Of course tuning MAX_CONNECTIONS goes WAY beyond the OP's
original question of "how many apps are connected to my database at peak
time?". :-)
Ian

Feb 21 '06 #11

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Jaime | last post: by
1 post views Thread by googlegroups | last post: by
2 posts views Thread by dmagliola | last post: by
5 posts views Thread by linda.chen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.