Number of simultaneous connection

[cdngo]

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

[Larry]

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

[Serge Rielau]

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

[cdngo]

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

[Bob [IBM]]

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

[Gert van der Kooij]

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.

[Joachim Klassen]

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

[cdngo]

Thanks everybody

Have a nice day

D.

[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.

[Bob [IBM]]

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

[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