Check or query number of connections

henrywong · #1 (**permalink**) 01-26-05, 21:42

How to check or count number of connetions or agents. I need these information to see how many connections/process are establisehd to DB2 by the applications. DB2 version is V8.1.

Hope for helps

Marcus_A · #2 (**permalink**) 01-26-05, 21:50

You can do a GET SNAPSHOT FOR APPLICATIONS. See the Command Reference for syntax details.

You can also submit this from a command prompt:

db2 list applications show detail

fohana · #3 (**permalink**) 01-27-05, 16:30

If you want to check the number of connections per database you can use the command LIST ACTIVE DATABASES.

Look for the field: Applications connected currently

Internet Services

Web Development

Digital Marketing

Consumer Tech